On Sat, 29 Apr 2006, Unit5 wrote:
[...]
2) Is there any difference, in terms of performance,
between a single database or two or more databases
attached to the default one?
3) When doing complex joins against two tables, is
there a difference between when the tables are in one
database or in two separate databases?
Hello,
there should not be much of a difference, if any. The question has
already recently been discussed on this list:
http://www.mail-archive.com/sqlite-users%40sqlite.org/msg14653.html
I mean syntactically, I would use the database.table name syntax but
other than that, is there a difference in terms of reliability or
efficiency?
If the table names are unique across databases you don't even have to
qualify them.
cu,
Thomas
