25M tables in one database -- wow. How big were the tables? Was this with MySQL? Which OS and filesystem did you run this on?
Given that MySQL stores each table in three separate files in the database directory, that would imply 75,000,0000 files in the directory containing the database -- and non-trivial directory search times every time MySQL had to open a file (i.e. database table or index), right? Or did you manage to configure MySQL to cache all these file handles so that it did not need to reopen the tables (and search the directory for the appropriate entries)? Tom Haapanen [EMAIL PROTECTED] -----Original Message----- From: Steve Meyers [mailto:[EMAIL PROTECTED]] Sent: 22 October 2001 03:27 To: Joe; [EMAIL PROTECTED] Subject: RE: Database Structures Creating a new table per image isn't unheard of -- at a company I used to work for, we estimated that we had around 25 million tables at one point in time. There were lots of factors that went into why our database was structured like that, but it worked for us. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
