Hi
I am writing an application which requires approximately 50,000 items to be
imported from a text file into a table. Each item is a single string of 8
characters, and the target table has an auto-incrementing PK and one other
field, to hold the 8 character string.
Using the "Import Table Data" function in SQLiteman, the data loads very
quickly. However in my application, using either an SQL "insert" command or a
resultset, the import is very much slower. Is there another technique I can use
to speed things up?
Thanks
Nige
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users