Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>As you've not said what you're using this file for I'm assuming that you are just searching for a word for some reason.</p> <p>First of all, its probably not a good idea to try and load the complete file into memory. Instead, it might more productive to search the file for the data (word) you need and also, perhaps, keep some sort of indexing information in memory to speed things up a bit. </p> <p>As the data you are trying to search is just a list of words it might be a good idea to scan the file and record in a dictionary where the first letter of a word changes. e.g A's start at line 0; B's start at line 200; C's start at line 300 etc. Use these two pieces of information to populate your dictionary; the letter is the key and the line number is the value. In effect, the dictionary becomes a high level index into the word list file. This dictionary is also very small. </p> <p>Then, when you start to search for a word, use the first letter of the word to search the dictionary. This will get you the line number where words that begin with that letter are located in the file. Armed with the line number (re)open the file and go straight to that line in the word file by moving stream pointer to the target line. Then search for the target word from there. Either search sequentially, a line at a time (not recommended it will be quite slow but will be easier to code). Or, search for the word using a <a href="http://en.wikipedia.org/wiki/Binary_chop" rel="nofollow noreferrer">binary chop</a> (much quicker, but harder to code). Although for the latter you'll also need to know where the words that start with the target letter stop in the file as you'll be search a section of the file. I'd also recommend that you do the word searching in the file rather than load all those words into memory, otherwise you might be back to where you start with OOM errors. </p> <p>If you're not sure of anything, stick a comment on here and I'll do my best to answer it. </p> <p>Good luck</p>
    singulars
    1. This table or related slice is empty.
    1. PO.net OutOfMemory exception
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USBarry Carr
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO.net OutOfMemory exception
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COGood input! BinarySearch is already being used whenever and wherever it's possible. While the 1st file (the word list) must be loaded as shown in my code (needed for other algorithms in my library), your idea is still good, especially in regard to the 2nd file which would mean I could avoid loading the 2nd file and load/access the same only when needed. Of course this would involve a lot of file-accessing and probably a quite substantial performance-loss but still....I will give it a shot! Thanks!
      singulars
      1. PO
      1. USmoster67
    2. COplease see my edit2 for some extra information regarding the library
      singulars
      1. PO
      1. USmoster67
    3. COThanks for the feed back. Is there any chance you could vote for my answer? ;-) Regarding the second file. You could try and search the file on a back ground thread, that at least should keep your UI responsive.
      singulars
      1. PO
      1. USBarry Carr
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload