in reply to SQLite Slow insert
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.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: SQLite Slow insert
by afoken (Chancellor) on Feb 17, 2013 at 19:29 UTC |
In Section
Seekers of Perl Wisdom