On Sun, 05 Dec 2010 11:27:01 +0000 Clive Eisen <cl...@serendipita.com> wrote:
> On 05/12/2010 10:52, Owen wrote: > > > > I have 445, 6 element csv files, about 350000 lines in all. I only > > have one machine, but a number of Linux OS. > > > > These csv files are parsed, the data checked for purity and then > > placed in an sqlite file. > > > > On one OS, this takes 30-35 minutes, on several other operating > > systems, it takes 7-8 hours. > > > > I am at a loss to understand why this is so. > > > > Are there any suggestions as to what may cause this anomaly? > > > > The version of SQLite is 3.6.13 > > > Um - we need more information > > Name the opsys (32 or 64 bit?) and their times > Name the file system types and their mount options where the sqlite > db resides and the respective times > Well, managed to bring the 8 hour time build down to 12 seconds, AutoCommit was set to 1, setting it to 0 fixed it all. Approx 0.08 seconds a commit, all adds up over 350000 records Owen
