Let's see if we can make the 7pm one. Eh Sent via BlackBerry from T-Mobile
-----Original Message----- From: wlof <[email protected]> Date: Fri, 4 Sep 2009 07:52:43 To: <[email protected]> Subject: Re: [sqlite] Slow SELECT query Sebastian Bermudez wrote: > > 1) > Ok, change the index to: > CREATE INDEX IF NOT EXISTS log_idx ON log (timestamp) > > column Id is not used for select... > the Id column just is needed for delete operation. > This seems to have done the trick. The SELECT query now takes ~15 ms. Much better :) I didn't think adding the id in the index would have such consequences! I take it adding an index on id AND timestamp is definitely not the same thing than adding an index on id AND adding an index on timestamp. Thanks a lot for your help! It is much appreciated. -- View this message in context: http://www.nabble.com/Slow-SELECT-query-tp25294597p25295851.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
