Complexity of the schema affects time required to open a connection since the schema has to be read and processed. With about 70 tables each with lots of indexes and triggers, it takes us 17ms to open the connection.
HTH, Sam ------------------------------------------- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -----Original Message----- From: Kiran Kumar.M.R [mailto:[EMAIL PROTECTED] Sent: Thursday, October 25, 2007 5:54 AM To: sqlite-users@sqlite.org Subject: [sqlite] Impact of no.of tables and records on Startup time Hi, When SQLite is used in on disk mode, What is the impact of no. of tables and records on the startup time. For example, 1. number of tables (10, 100, 1000 tables, each having 100 records, each record 256 bytes) 2. number of records in a single table (1 table, having 10,100,1000,100000 records, each record 256 bytes) Will the startup time get affected? If yes in what order? Thanks, Kiran ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------