Quoting Alberto Daniotti <albertodanio...@libero.it>:

> Good Morning.
> 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.

How often would you need to do that? If it's a one-time initialization  
of your database, I can't imagine why using INSERT is too slow. If it  
really is, all you can do is to ship an existing database with the  
table already loaded (a SQLite database is just one file). If that is  
not possible, you may have to rewrite your code to avoid implicit  
transactions around each INSERT statement, see  
http://www.sqlite.org/faq.html#q19

regards,
Markus


-- 
Markus Hoenicka
markus.hoeni...@cats.de
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to