Please send private email to d...@sqlite.org. CC to d...@sqlite.org and j...@sqlite.org.
On Mon, Jan 9, 2012 at 11:09 AM, John Elrick <john.elr...@fenestra.com>wrote: > Sorry "The combined files are 2.4 MB zipped" > > On Mon, Jan 9, 2012 at 11:09 AM, John Elrick <john.elr...@fenestra.com> > wrote: > > Richard, > > > > I have the information available for you. Unfortunately, it appears > > that I cannot actually reduce the case, however, the issues appear to > > be fairly confined. > > > > The test database is 6 MB and I have a database showing the > > performance tracking for each of the queries which is about 140KB. > > The combined files are 2.4 MB. How would you prefer I send this file > > to you? > > > > On Fri, Jan 6, 2012 at 4:51 PM, John Elrick <john.elr...@fenestra.com> > wrote: > >> Yes. Look for it on Monday. I'm about to leave for the day. The > >> queries are automatically generated and will require some mining to > >> get specific examples. I should be able to reduce the range to a > >> simple repeatable case but it may take a while. > >> > >> Thanks very much and have a great weekend. > >> > >> On Fri, Jan 6, 2012 at 4:42 PM, Richard Hipp <d...@sqlite.org> wrote: > >>> 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 > >> > >> > >> > >> -- > >> John Elrick > >> Fenestra Technologies > >> 540-868-1377 > > > > > > > > -- > > John Elrick > > Fenestra Technologies > > 540-868-1377 > > > > -- > 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
