Databases
StackOverflow2013
Postsdbo
POUISearchDisplayController and search performance with lots of data
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUISearchDisplayController and search performance with lots of data
    text
    copied!<p>I'm trying to figure out the best way to perform a fast search using a <code>UISearchDisplayController</code>.</p> <p>I have a plist file with more than 36000 entries. I load this file in a dictionary and I perform the search in this dictionary. It works but it's kinda slow and there is lag between each touch event. I want an autocompletion effect so I need the search to be triggered for each touch event.</p> <p>I tried using thread to perform the search in background with the following code :</p> <pre><code>- (BOOL)searchDisplayController:(UISearchDisplayController *)controller shouldReloadTableForSearchString:(NSString *)searchString { [NSThread detachNewThreadSelector:@selector(filter:) toTarget:self withObject:searchString]; return NO; } // Filter function looks like this -(void) filter:(NSString *)search { NSAutoreleasePool *pool = [[NSAutoreleasePool alloc] init]; [self.filteredList removeAllObjects]; // empty array of results for (NSString *s in self.keys ) { NSComparisonResult result = [s compare:search options:(NSCaseInsensitiveSearch|NSDiacriticInsensitiveSearch) range:NSMakeRange(0, [search length])]; if (result == NSOrderedSame) { [self. filteredList addObject:s ]; } } [ self.searchDisplayController.searchResultsTableView reloadData]; [pool release]; } </code></pre> <p>But my application crashes randomly with the following message: </p> <pre><code>Terminating app due to uncaught exception 'NSRangeException', reason: '*** -[NSCFArray objectAtIndex:]: index (1) beyond bounds (0). </code></pre> <p>I'm sure it's because I dont use threading properly.</p> <p>I also tried using <code>[self performSelector:@selector(filter:) withObject:searchString afterDelay:0.5];</code> but I'm also facing application crashes.</p> <p>What is the best way to handle this ? I'm not really good with threads but I think it's the best way to go, isn't it ? I also tried a solution with SQLite but the application is still not so responsive.</p> <p>My data are actually zip codes and cities (36000 unique different cities but 6500 unique zip codes since multiple cities can have the same zip code). I want my search item to be either a zip code or a city name. I know that one big dictionary is definitely not the best structure. How could I organize my data for more efficiency?</p> <p>Thank you for helping me with this.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

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