.read FILENAME Execute SQL in FILENAME

When I want to restore a database. I execute a command in sqlite3 with
".read file" then execute my sql statements in the named file.

There were about two hundred thousand of insert statements, but it
executed too slow.

I checked the source code and it will always realloc and free many times
when the file is a little large.

So maybe it need to find a more efficient way to read and execute sql
statements from file.


Thanks,

taorundong



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

Reply via email to