Hello Mike,
Did you say that the PRAMGA locking_mode=EXCLUSIVE was set ? The doc suggests this speeds things up ... I have that set, yes. You are not clear about which aspect is slow - are you already using sqlite3_bind_x() and placeholders (?) in your SQL statements ? Doing a sqlite3_prepare every time you do a query can slow things down. I am using the sqlite.exe command line executable in a separate thread to query my database. I don't have code level control over the access to it. I was thus wondering if there is anything i can do on a query level (as input to the command line executable) to speed things up. Any help is much appreciated, christophe Leske _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
