.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