Re: [sqlite] SQlite query performs 10 times slower than MS Access query

und 1 sec (when I ran the query the second time). The execution time of the first time I run my query varies wildly, I dunno why. Any ideas? Thanks in advance! Regards, Saswati Igor Tandetnik wrote: > > Doyel5 wrote: >> I have a 800MB MS Access database that I migrated to SQLite.

[sqlite] SQlite query performs 10 times slower than MS Access query

I have a 800MB MS Access database that I migrated to SQLite. The structure of the database is as follows (the SQLite database, after migration, is around 330MB): The table ‘Occurrence’ has 1,600,000 records. The table looks like: CREATE TABLE Occurrence ( SimulationID INTEGER,SimRunID IN