sqlobject-discuss

[SQLObject] Faster Loading of Data to SQLite3

[Massimo <lo....@gm...>]

I'm using SQLite3 and loading datafiles of about 50,000 lines. The script
takes a long time to update, probably because it keeps hitting the hard disk
with every insert/update command. How can I speed up this process?

Re: [SQLObject] Faster Loading of Data to SQLite3

[Oleg B. <ph...@ph...>]

On Sat, Apr 16, 2011 at 05:31:52PM -0400, Massimo wrote:
> I'm using SQLite3 and loading datafiles of about 50,000 lines. The script
> takes a long time to update, probably because it keeps hitting the hard disk
> with every insert/update command. How can I speed up this process?

   Don't use highest-level SQLObject API, use middle-level SQLBuilder:
http://sqlobject.org/FAQ.html#how-to-do-mass-insertion
http://sqlobject.org/SQLBuilder.html#insert
   Hope this helps.

Oleg.
-- 
     Oleg Broytman            http://phdru.name/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.