On Oct 21, 2010, at 9:27, Simon Slavin wrote:
> Have you actually demonstrated this ? In other words do you have an
> operation that's really 'too slow', but after a VACUUM it's fast enough ?
Yes.
Select * from a table took just slightly under three hours.
Select * from a reconstructed table (insert into select from) in a new
database took 57 seconds.
--
Dustin Sallings
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
