Can you publish for us: (1) A sample database (2) The specific queries that are causing your problems
So that we can investigate further? On Fri, Jan 6, 2012 at 4:31 PM, John Elrick <john.elr...@fenestra.com>wrote: > 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 > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
