I have run into a serious performance problem with tables with many rows. The problem only occurs on tables with an index The time needed for an insert into a table with an index is dependend on the number of rows. I have not formally checked, but from my tests it looks like an exponential dependence. This of course means that while sqlite is very fast on smaller datasets, it is slow on larger data sets and becomes unusable on large datasets (million of rows). The insert behaviour is normal on non indexed tables, but obviously queries are a problem then. Is this index behaviour normal/expected for sqlite, or can this be solved?
-- Dr Peter De Rijk E-mail: [EMAIL PROTECTED] Bioinformatics Unit Tel. +32 3 265 10 08 Department of Molecular Genetics VIB8 Fax. +32 3 265 10 12 University of Antwerp http://www.molgen.ua.ac.be/ Universiteitsplein 1 B-2610 Antwerpen, Belgium The glass is not half full, nor half empty. The glass is just too big. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
