On Fri, 20 May 2011 20:33:04 +0900, Hyoseok Kim <toriwo...@gmail.com> wrote:
>Hi, I'm Hyoseok Kim from Korea. > >I develop a app on iphone. I use SQLite for about 120,000 data. In my code, >sqlite3_step hold 0.5~1.0 sec. >Please give me a hint to escape sqlite3_step method rapidly. > >Please help me. >Thank you so much. > > >My code is below... > > if (sqlite3_prepare_v2(db, query_stmt, -1, &statement, NULL) == >SQLITE_OK) { > > int rowCount = 10; > while (sqlite3_step(statement) != SQLITE_DONE) { > // Some code to retrieve values > // Looping... > > // 0.5~1.0 sec hold after read last row data. > } > } It all depends on the schema, the SELECT statement you use and the exact working of the loop. With the information you gave it is hard to tell what is happening. If you for example SELECT all rows, but only use the first 10 and step through all other rows without processing them, you force the sqlite engine to finish the query. You could stop stepping after the last row you want to process by leaving the while loop and calling sqlite3_reset(). This papge might be of interest for you: http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users