Can cache and page size configuration improve or worsen the situation? regards ragha ****************************************************************************************** This email and its attachments contain confidential information from HUAWEI, which is intended only for the person or entity whose address is listed above. Any use of the information contained herein in any way (including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than the intended recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by phone or email immediately and delete it! *****************************************************************************************
----- Original Message ----- From: "Samuel R. Neff" <[EMAIL PROTECTED]> Date: Thursday, October 25, 2007 6:16 pm Subject: RE: [sqlite] Impact of no.of tables and records on Startup time > > Complexity of the schema affects time required to open a connection > sincethe 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,100000records, each record 256 bytes) > > Will the startup time get affected? If yes in what order? > > Thanks, > > Kiran > > > -------------------------------------------------------------------- > --------- > To unsubscribe, send email to [EMAIL PROTECTED] > -------------------------------------------------------------------- > --------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
