Hello, The Sqlite3 manual says that any locking operations affect the entire database, not individual tables. http://www.sqlite.org/lockingv3.html
I was wondering if this effect could be compensated for by splitting tables into separate databases and using the "attach database" option outlined here: http://stackoverflow.com/questions/6671678/objective-c-sqlite-join-tables-from-multiple-database I would assume that the databases will not become locked until the statement is executed (i.e., preparing the statement won't lock it). Is that correct? If so, is there a significant disadvantage or performance hit to using this workaround? Thanks, -Ian -- Ian Katz Research Software Engineer, MIT LAMSS i...@mit.edu _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users