On 12/16/2015 12:51 PM, ??? wrote: > After testing the Sqlite3_open and ATTACH DATABASE, > I found that the attach database is slower than sqlite3_open. > there is attachment after the mail which includ the speed > information ( millisecond ).
Hi, This mailing list strips attachments, so you'll need to include the information inline. One possible explanation: When you run an ATTACH statement, SQLite opens the new database file and reads the schema from the sqlite_master table. Whereas sqlite3_open() just opens the db file (reading the schema is deferred until it is first required in this case). So an apples/apples comparison might be to open/ATTACH the database and then run a simple query that forces SQLite to read the database schema if it has not already - say "SELECT * FROM sqlite_master". Dan.
