Thank you for your response. I will try and find out things here first, now that I know that the new version should be faster, not slower. If i cannot determine the reason, then i will post my exact schema and statements.
Martin Am 16.12.2010 13:19, schrieb Richard Hipp: > 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 >> > > -- *Codeswift GmbH * Kräutlerweg 20a A-5020 Salzburg Tel: +49 (0) 8662 / 494330 Mob: +49 (0) 171 / 4487687 Fax: +49 (0) 3212 / 1001404 engelsch...@codeswift.com www.codeswift.com / www.swiftcash.at Codeswift Professional IT Services GmbH Firmenbuch-Nr. FN 202820s UID-Nr. ATU 50576309 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
