On Thu, Dec 16, 2010 at 4:01 AM, Martin Engelschalk < engelsch...@codeswift.com> wrote:
> Hello List, > > i tried switching from Version 3.2.5 to 3.7.4 to make use of the new > features. > > I create a new database file and load 1.000.000 records into a single > table. > Without changing anything in my own code (which reads from a file and > does additional processing before inserting the records), my program > runs about 50% slower (89 secs instead of 57 secs) > > Is this expected? Can i do anything to reach the old perfomance? > 3.7.4 should be faster than 3.2.5, not slower. But without further knowledge of what your are doing (your schema and the queries you are running, at a minimum) we cannot help you figure out what is going on. > > I am on C++ and Windows and compile the amalgamation. I use one large > transaction and bind variables. > > Thanks, > Martin > > _______________________________________________ > 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
