Background ========= We have been using Sqlite3 in a project since 2007. Because of the release cycles involved, we normally upgrade infrequently. We recently upgraded from 3.6.7 to 3.7.9 and encountered two serious issues. We need assistance in narrowing down the causes.
We are developing using Delphi. We are using the amalgamation and are compiling it using the free Borland BCC complier. The result is an obj file which is statically linked into our application. We have been using this technique since we began using Sqlite. In the tests below, the strategy for changing between versions is to change which obj file is statically linked into the application. The application was recompiled between each test. Issues Encountered =============== 1. After changing there is an order of magnitude performance reduction. Using GP Profile to monitor operations, here are the results for identical application uses: Operation executes _sqlite3_step 49,152 times 3.6.7 time 5.24 seconds 3.7.9 time 41.19 seconds 2. During testing we encountered a bug which had not been encountered before. Research by our CTO established that in 3.7.9 a row was returned from this query which contained empty values. In 3.6.7 there were no results from the query. Summation ========= Given how throughly Sqlite is tested I have difficulty believing there is an actual bug in Sqlite. I believe an interaction is occurring which is a result of changes to the Sqlite code base which are producing unexpected resulted when compiled into our application. To help resolve the problem, I would like to know if there is an historical record of the amalgamations. If so, I can carry out testing to determine in what version the problem manifests. If anyone has any other recommendations I would be pleased to hear them. For the moment we are reverting to 3.6.7 as a temporary solution. -- John Elrick Fenestra Technologies 540-868-1377 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
