Thank you for the answer. Could you give me an example of use of BEGIN TRANSACTION? Thanks
----- Original Message ----- From: "Simon Slavin" <slav...@hearsay.demon.co.uk> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Tuesday, July 07, 2009 1:22 PM Subject: Re: [sqlite] Importing file from C-code > > On 7 Jul 2009, at 10:39am, Alberto Daniotti wrote: > >> I have a question. I want integrate sqlite in a c-program. I want to >> know if is possible import a table from a external text file without >> using INSERT (it's too slow) and if it's how i must do. > > If INSERT is too slow for you, you probably are not using transactions > correctly. Use a 'BEGIN TRANSACTION' before the first INSERT and a > 'COMMIT TRANSACTION' after the last one. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -------------------------------------------------------------------------------- Nessun virus nel messaggio in arrivo. Controllato da AVG - www.avg.com Versione: 8.5.375 / Database dei virus: 270.13.6/2221 - Data di rilascio: 07/06/09 17:54:00 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
