hi
I noticed that function sqlite3_step() is very slow when i want to fetch query with join(s). For example : create same table t (a int, b int, c int ... ); and insert into t large numbers of records, (about 10000) time of fetching select * form t limit 0,100 is this same what select * from t limit 9000,100; but when i want to use "join", like : select * from t join t2 on (t2.id=t.a) join t3 on (t3.id=t.b) ... , there is big difference between fetching this query with limit 0,100 and limit 9000,100; anyway using subselects insted of joins take this same time with both limits. Is it a bug ? Thanks Iv