I need to know if there are some order of penalty in attach (2+) databases to make a small (3 tables) join....... (one table per DB)..... vs. (3 tables on same DB). I need it to get a small order concurrency writes... I have 3 process writting to one to each DB..... but i need query everithing with a join..... DBs are in journal mode WAL. because i have other 4th. process doing select on each db at same time. the question is, there are some order of penalty in attach (2+) databases vs one big DB ? Pd: one of 3th DB... is getting 100mb at month (incremental)... to max of 2.4GB (2 years). when it is cleaned. Pd2: Sorry for my bad english.
att sebatian _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users