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

Reply via email to