[Igor Tandetnik]
> If you need a particular order, it's best to add an explicit ORDER BY.
> Otherwise, you are at the mercy of an implementation. Your current version of
> SQLite chooses an execution plan that happens, by accident, to produce rows
> in the desired order. Tomorrow you upgrade to a new version, and it chooses a
> different execution plan that results in a different order.
I feared that. As it is, it takes 6 seconds to do a SELECT * FROM
Combined LIMIT 1 ("Combined" is a view representing the merged table).
If I add an ORDER BY, it takes 35 seconds.
Any way to speed up the ordering?
I think I'll need the ordering to do interpolation.
--
Steinar
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
