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

Reply via email to