Databases
StackOverflow2013
Postsdbo
POLoading 10k+ rows in iphone SQLite (FMDB)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POLoading 10k+ rows in iphone SQLite (FMDB)
    primarykey
    data
    text
    <p>I am creating a dictionary app and I am trying to load the terms into an iphone dictionary for use. The terms are defined from this table (<a href="http://www.sqlite.org/" rel="nofollow">SQLite</a>):</p> <pre><code>id -&gt; INTEGER autoincrement PK termtext -&gt; TEXT langid -&gt; INT normalized -&gt; TEXT </code></pre> <p>Normalized is used because I am writing in GREEK and I don't have icu on the sqlite engine for searching diacritics, so I am making a termtext diacritics/case insensitive. It is also the main search field, in contrast of termtext which could be the "view" field.</p> <p>I have defined an class (like a POJO) like this:</p> <p><b>terms.h</b></p> <pre><code>#import &lt;Foundation/Foundation.h&gt; @interface Terms : NSObject { NSUInteger termId; // id NSString* termText; // termtext NSUInteger langId; // langid NSString* normalized; // normalized } @property (nonatomic, copy, readwrite) NSString* termText; @property (nonatomic, copy, readwrite) NSString* normalized; @property (assign, readwrite) NSUInteger termId; @property (assign, readwrite) NSUInteger langId; @end </code></pre> <p><b>terms.c</b></p> <pre><code>#import "Terms.h" @implementation Term @synthesize termId; @synthesize termText; @synthesize langId; @synthesize normalized; @end </code></pre> <p>Now in my code I use <a href="https://github.com/ccgus/fmdb" rel="nofollow">FMDB</a> as the wrapper for the <a href="http://www.sqlite.org/" rel="nofollow">SQLite</a> database. I load the terms using the following code:</p> <pre><code>[... fmdb defined database as object, opened ] NSMutableArray *termResults = [[[NSMutableArray alloc] init] autorelease]; FMResultSet *s = [database executeSQL:@"SELECT id, termtext, langid, normalized FROM terms ORDER BY normalized ASC"]; while ([s next]) { Term* term = [[Terms alloc] init]; term.termId = [s intForColumn:@"id"]; [... other definitions] [termResults addObject:term]; [term release]; } </code></pre> <p>The whole termResults is then loaded to a <a href="http://developer.apple.com/library/ios/#DOCUMENTATION/UIKit/Reference/UITableView_Class/Reference/Reference.html" rel="nofollow">UITableView</a> (on viewdidload) but the loading takes up to 5 seconds every time I start my app. Is there any way to speedup that process? I have indexed id, termText and normalized on <a href="http://www.sqlite.org/" rel="nofollow">SQLite</a>.</p> <p><strong>* UPDATE: added cellForRowAtIndexPath **</strong></p> <pre><code>[.. standard cell definition...] // Configure the cell Term* termObj = [self.termResults objectAtIndex:indexPath.row]; cell.textLabel.text = termObj.termText; return cell; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCesar A. Rivas
    1. USPanagiotis
    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. POLoading 10k+ rows in iphone SQLite (FMDB)
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POLoading 10k+ rows in iphone SQLite (FMDB)
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    3. VO
      singulars
      1. POLoading 10k+ rows in iphone SQLite (FMDB)
      1. USFranck
      1. VTFavorite
    1. COYou should check, but I think the while loop is killing you. Is there any reason to move your results to an array? I assume you are using that to populate the tableview. If that is the case then just use the result set object in your datasource. There is nothing that says you NEED to use an array for that as long as you know how to get your objects out.
      singulars
      1. POLoading 10k+ rows in iphone SQLite (FMDB)
      1. USsosborn
    2. COIs it really necessary for you to have all those objects live at runtime ? Can't you load them from DB on demand and cache them ?
      singulars
      1. POLoading 10k+ rows in iphone SQLite (FMDB)
      1. USDarkDust
    3. COCan you show us the cellForRowAtIndexPath method definition?
      singulars
      1. POLoading 10k+ rows in iphone SQLite (FMDB)
      1. USPraveen-K
 

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