Databases
StackOverflow2013
Postsdbo
POIOS word game. Validate word performance
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIOS word game. Validate word performance
    primarykey
    data
    text
    <p>I'm building a scrabble game, and having some problem with the word dictionary. It contains ~700,000 words, and about 18 MB big. </p> <p>Right now, I'm loading the whole dict into an array, which takes 12 seconds on an iPhone 4. </p> <pre><code>wordList = [NSMutableArray arrayWithContentsOfFile: [[self applicationDocumentsDirectory] stringByAppendingString:@"/wordlist.plist"]]; </code></pre> <p>I have two questions: </p> <ol> <li><p>Is there a better way to load the wordlist faster and/or reduce memory? </p></li> <li><p>It takes about 12 seconds to get all possible words from a set of letters. Is it possible to make it quicker? Here's the code: </p> <pre><code>-(NSMutableArray *)getValidWords:(NSString *)letters{ NSMutableArray *list = [[NSMutableArray alloc] init]; for (int i = 0, c = [wordList count]; i &lt; c; i++){ if ([self isWordValid: [wordList objectAtIndex: i] forLetters:letters]){ [list addObject:[wordList objectAtIndex: i]]; } } return list; </code></pre> <p>}</p> <pre><code>- (BOOL)isWordValid:(NSString *)word forLetters:(NSString *)ltrs{ int i, z; NSRange range; BOOL found; static NSMutableString *letters = nil; if ([word length] &lt; 2) return NO; if(letters == nil) { letters = [[NSMutableString alloc] initWithString:ltrs]; } else { [letters setString: ltrs]; } found = NO; range.length = 1; for(i = 0; i &lt; [word length]; i++){ for(z = 0; z &lt; [letters length]; z++){ if([word characterAtIndex:i] == [letters characterAtIndex:z]){ range.location = z; [letters deleteCharactersInRange: range]; found = YES; break; } } if (found == NO){ return NO; } found = NO; } return YES; } </code></pre></li> </ol>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPopeye
    1. USBlackMouse
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POIOS word game. Validate word performance
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POIOS word game. Validate word performance
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. POIOS word game. Validate word performance
      1. USiGelert
      1. VTFavorite
    1. COhttp://codereview.stackexchange.com ?
      singulars
      1. POIOS word game. Validate word performance
      1. USSulthan
    2. COHaven't got an answer for you (yet) but there are some oddities in your code: You define the NSMutableString instance letters as nil. Then you check if it is nil and give it a value a few lines later. You could simply define it with the received ltrs parameter immediately.
      singulars
      1. POIOS word game. Validate word performance
      1. UST. Benjamin Larsen
    3. COA [pre-populated coredata db](https://www.google.com/webhp?q=core+data+prepopulate+tutorial#hl=en&tbo=d&output=search&q=core+data+prepopulate+tutorial&oq=core+data+prepopulate+tutorial) would be the way to go...
      singulars
      1. POIOS word game. Validate word performance
      1. USAlladinian
 

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