Hello- 

 

I have few questions regarding usage-model of multiple databases with
SQLite. I understand SQLite allows for attaching multiple databases in a
single session. My questions are:

*        Do the schema for multiple databases need to be same for
attaching with SQLite in single session?

*        Is there any performance penalty for multiple databases,
especially with different schemas? Has someone done any benchmarking on
this front? 

*        Are there any BKM's for how to use multiple databases with
SQLite with different schemas, especially with query/select/join
statements

*        Any document pointers/code-examples for how to use multiple
database with different schemas?  

 

Thanks. 

 

Rajan

Reply via email to