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. } } _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users