I have investigated more.
It seems that the performance problem is simply
related to the query:
SELECT MAX(DTFROM) AS MAXDT, IDCATALOGUE FROM
CRONOCATALOGUES GROUP BY IDCATALOGUE
which takes at first execution 9 seconds in access and
30 seconds in sqlite, and it takes, after first
execution (OS cache), about 5 seconds in access and 10
seconds in sqlite.
It's a really very big difference, and I don't think
it is possible to optimize this simple query. In this
case, access seems to be really faster.
(just to remember, CRONOCATALOGUES table has 2 700
000 records)
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
