On Thu, Oct 07, 2010 at 05:22:19PM +0100, Simon Slavin scratched on the wall:
> On 7 Oct 2010, at 5:05pm, Michele Pradella wrote:
> 
> > The DB is indexed by a DateTime column (is a 64 bit integer)
> 
> Do make sure that that column is declared as INTEGER and that there
> is an index on it.

  When deleting 20 to 25% of the rows, an index is likely to slow
  things down.

   -j

-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it,
 but showing it to the wrong people has the tendency to make them
 feel uncomfortable." -- Angela Johnson
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to