Hello,
I've read that sqlite locks the entire database file on updates. Our database is based on a very small number of tables that contain a huge amount of records (under WAL mode). Will we get improvements in performance if we create different database files (one for each table) and attach them to a single connection? Will the files be locked indipendently? Thanks. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users