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 declared tables.
Is there a "safe" maximum number of tables that doesn't negatively impact too much sqlite3_open()? I wonder if it's 10, 25...?
Any ideas? Thanks, -- Tito