[sqlite] Why does the order of indexed columns matter when creating an index?

Hello, I've looked for an explaination in the following pages without success: http://www.sqlite.org/optoverview.html http://www.sqlite.org/cvstrac/wiki?p=QueryPlans So I hope someone can help me... CREATE TABLE node( id INTEGER PRIMARY KEY, name TEXT ); CREATE TABLE edge( orig INTEGER

[sqlite] Increase SQLITE_MAX_VARIABLE_NUMBER

Hello, Currently, we are using lucene to do full-text search (may be we will switch to FTS3). And we inject all the ids returned by lucene in prepared statements to load the data. But we have to check that the ids collection size is not greater than SQLITE_MAX_VARIABLE_NUMBER (999 by default)

[sqlite] Success in extending genfkey

Hello, If you are interested, i successfully extended the genfkey tool to make sure all declared foreign keys have an associated index. Tables 'temp.idx2' and 'temp.idx' cannot be reused because of the 'il.isunique' clause... Thanks Dan for your response in the previous post. Thanks all for

[sqlite] genfkey tool

Hello, I discovered the great 'genfkey' tool with the last release (3.6.4). And I tried to customize it such as the output is not "CREATE TRIGGER" statements but "SELECT" statements. Indeed, my SQLite database is populated from a MySQL dump and is not modified afterwards. The order of record