SQLite parses the schema every time you open a new connection so the more complex the schema the longer it will take to connect. We have 74 tables in our database with a lot of triggers and it takes 17ms to open a connection. So even if it will let you create 10,000, the performance impact of parsing the schema each time may be prohibitive (although if you can open one connect and leave it open for a long period of time, you can mitigate the parsing issue).
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, July 20, 2007 4:25 AM To: SQLite Subject: [sqlite] How many table can i create in a db? I open one db,then create table. How many table can i create? 10,100? what is the max table num in one db? BR allen.zhang ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
