On 20 May 2011, at 12:33pm, Hyoseok Kim wrote: > 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. > [snip] > > // 0.5~1.0 sec hold after read last row data.
Do you get the long pause 0.5~1.0 sec after each row, or only after the last row of data ? Are you using 'SELECT * FROM ...' or are you naming the columns you want ? Can you supply us with your 'SELECT' command, or an example of it ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users