[sqlite] Followup: Order of operations to recycle setting records

first. Sorry! cheres ben Ben Supnik wrote: Hi Y'all, I am using a loop to insert multiple values into a table... INSERT INTO WED_selection(id,item) VALUES(@id,@item); where id and item are my two parameters...WED_selection is a table whose primary key is PRIMARY KEY(id,item). my code loop

Re: [sqlite] Indexing on multiple columns

Hi, Fascinating, thanks!! :-) Indeed this query does use the optimizer. :-) If I understand, by rewriting the query to have an AND statement at the top level and getting a simple comparison over to the left we can utilize the index. *cheers* Ben [EMAIL PROTECTED] wrote: SELECT name

[sqlite] Indexing on multiple columns

Hi Y'all, Is there a compact way (or is it even possible) to use multiple columns (that I have in my order-by clause) for an operator like > or >=? I have a database of airports, something like this: create table airports( id integer primary key, name varchar not null); create index

[sqlite] Dumb Newbie Question - Comparison if sqlite index to STL

Hi Y'all, Please forgive what I think is probably a dumb question, but... I am porting my app's data model from C++/STL to sqlite. My goal is scalability - even if I implement my data model in C++ using data structures that give me good O(N) time (e.g. use trees, hash tables, etc.) the