On Tue, 26 Oct 2010, Dariusz Matkowski wrote: > Queries will be done across the servers to aggregate the content. I am > concern about the locking mechanism, if I write to the single database and > I represent the servers as tables I will have no access to read the other > servers/tables, but if I distribute the servers across different DBs I can > write into one and the other ones are open to read.
How frequently are data written to the tables? How much data per write? It appears that you want to use separate databases for each server so you might try that and see how well it works for you. Rich _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
