Just another Perl shrine | |
PerlMonks |
Re: SQLite and CPU Usageby paulbort (Hermit) |
on Aug 03, 2004 at 17:58 UTC ( [id://379764]=note: print w/replies, xml ) | Need Help?? |
All of the suggestions about batch inserts are right on, I would just like to add one minor point since you mentioned indexes: If you are going to need the indexes later, it is usually faster to build the indexes after all the inserts are done, becaus this minimizes the number of times that index pages have to be re-arranged.
-- Spring: Forces, Coiled Again!
In Section
Seekers of Perl Wisdom
|
|