SQLite Forum

General question concerning database stucture and number of databases to use.
Login
Using database or table names as data is generally a bad idea, unless there are compelling reasons to do so.

One of the reasons is that the table name must be already know at prepare time and you will be wasting a lot of time building nearly identical SQL queries with just the table name changing instead of preparing just one statement and binding the portfolio name.

Another is that preparing a statement includes searching for the definitions of the tables and that takes longer for a large number of tables.