Thomas Briggs wrote: > How much slower is the index than your pre-populated table? If > you're really comparing apples to apples it would be good to know how > big the different is. > > If you post your schema and queries you'll probably get better > advice. At that this I'm just guessing. > > -T > > Not talking much, with about 1000 rows the difference is around 0.15 seconds. But the user experience is the difference between instant and a slight delay. I don't have any memory problems and so this seems like a good idea.
Andrew _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
