On 7 Apr 2014, at 7:33pm, J Trahair <j.trah...@foreversoftware.co.uk> wrote:
> Would having a field index or key help? Adding more indexes and keys make searches faster, at the expense of making the original INSERT slower. As a test, instead of executing the INSERT commands, write the commands themselves to a text file. Then add a BEGIN and the beginning and an END at the end. Then use the shell tool to .read that file. Is is faster or slower than your VB code ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
