Re: [sqlite] "Safe" maximum numbers of tables?

2006-03-24 Thread drh
Tito Ciuro <[EMAIL PROTECTED]> wrote: > Hello, > > I was reading the FAQ and I came across this statement: > > > > In practice, SQLite must read and parse the original SQL of all > > table and index declarations everytime a new database file is > > opened, so for the best performance of

[sqlite] "Safe" maximum numbers of tables?

2006-03-23 Thread Tito Ciuro
Hello, I was reading the FAQ and I came across this statement: In practice, SQLite must read and parse the original SQL of all table and index declarations everytime a new database file is opened, so for the best performance of sqlite3_open() it is best to keep down the number of