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/ p...@phdru.name Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------------------------------ Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
