Re: [sqlite] sqlite3_step hold about 0.5sec in iphone.

2011-05-21 Thread Simon Slavin
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.

Re: [sqlite] sqlite3_step hold about 0.5sec in iphone.

2011-05-21 Thread Kees Nuyt
On Fri, 20 May 2011 20:33:04 +0900, Hyoseok Kim 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

[sqlite] sqlite3_step hold about 0.5sec in iphone.

2011-05-21 Thread Hyoseok Kim
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,