Hi,
We are updating the version of sqlite from 3.7.3 to 3.7.13 in our software. But we are having a performance problem and I suspect a new configuration but I don't know which one. I read on the site but didn't find anything obvious. We use sqlite to store our graphical page objects data. It generate very small amount of data but we have between 100 and 300 sqlite files to open and close. At initialisation of the software we have to access all files to read some needed data. Doing it with 3.7.3 take around 2 ms per file but with 3.7.13 it take 1.3 second for the same call (select statement). We are using : C++ (CppSQLite3 wrapper), ADO, Sqlite ODBC driver Window 7 64 bits but the application is 32 bits. The select is simple Select from PAGE where name = "aux_control" and the result is always one row. My question what changes in SQLite can have this kind of impact on the performance? Thanks for your help. Stéphane Léger, ing. Technical Specialist HMI Group Marine Control System L-3 MAPPS 514 787-4877 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
