On 10 Feb 2012, at 3:24pm, Steinar Midtskogen wrote:
> 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?
Are you putting the ORDER BY in the VIEW definition or the SELECT definition ?
Whichever you're doing, try the other one. Also, is there an index which
provides a sorted list in an order which suits your ORDER BY clause ?
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
