Re: [sqlite] Better way to get records by IDs

Hi Jose, > I would like to get a bunch of records of IDs that I already know. For > example, this table called Jobs, > rec,...,data,... > 1,...,aaa,... > 2,...,zzz,... > ... > ... > 99,...,azz,... In addition to the pure syntax answer of other, I suggest you also consider your broader

Re: [sqlite] Performance of getting selected columns vs getting all columns

On 21 May 2011, at 8:38pm, romtek wrote: > I've just tested with a query I was working on with an SQLite management > tool and noticed that selecting all fields took at least *twice as long* as > selecting only two, and I don't have a huge number of columns (only 18). And > I am not sure if I

[sqlite] Performance of getting selected columns vs getting all columns

Hi, I used to think that getting selected fields from a relational DB is faster than getting all fields, so I used to carefully selected only those that I needed for a particular task. However, this is time-consuming (for a developer) and error prone. So, I've relaxed my rules on occasions. And

Re: [sqlite] C++ Sample Code

Don, I think Simon answered your question. To back up Simon's statements below, the C functions shown at ../quickstart.html are compiled nicely by any C++ compiler. I use Codegear C++ Builder and the amalgemation compiles without a single error or warning (I am impressed). SPEAKING of C++

Re: [sqlite] Example/Tutorial for "extension_functions.c" in C/C++ Prog With "sqlite3.c"

Thanks! I will download your updates and try to compile them! Steve. On 5/15/2011 3:27 PM, Ulrich Telle wrote: > Am 15.05.2011 20:43, schrieb Amy and Steve: >> Thanks! I will study the sqlite3_auto_extension closer. I had trouble >> compiling the extc file, but I can't remember what the

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

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.

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.

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,