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

Reply via email to