Welcome to the Monastery | |
PerlMonks |
Re: SQLite Slow insertby Corion (Patriarch) |
on Feb 17, 2013 at 19:21 UTC ( [id://1019194]=note: print w/replies, xml ) | Need Help?? |
As you don't show us how your database is constructed, or how you open the DB connection, it's somewhat hard to guess. I suggest looking at the Performance section of the DBD::SQLite documentation. Consider whether loading the data in an atomic transaction is OK for you. Also see http://bobby-tables.com/, because your way of constructing the insert statement is liable to fail with embedded single quotes. Use placeholders there.
In Section
Seekers of Perl Wisdom
|
|