SQLite import with AutoCommit turned off

Дата публікації:
25/09/2023 13:00

Постійна адреса новини:
http://www.vsinovyny.com/10390048

SQLite import with AutoCommit turned off

25/09/2023 13:00 // Perl Weekly newsletter

Importing CSV files into SQLite using perl (or I guess any other programming language) is slow. One can use the native .import command or one can turn of AutoCommit and commit all the inserts only at the end of the run.

» Читати повністю

«	Наступна новина з архіву 5 years on, we're still benefiting from Perl::Critic — but we've changed approach	Попередня новина з архіву Why I Created Venus	»