Just to give an example of what Shawn is saying is very TRUE. My MS-Access databases department-wide, the largest one is - 39 tables.
On MySQL side enterprise-wide database - 340 tables Best, Mikhail Berman -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, December 12, 2005 9:36 AM To: Charles Walmsley Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: PHP4 or PHP5? You are most welcome. As a comment to Fester: sometimes even 40 tables are not enough for a single application. Once you start dealing in enterprise-level data systems, 40 tables is how many you wish you had. I am sure there are some applictions using several hundred tables out there and doing just fine. You can't judge the size of a database by the number of tables it has so this may very well be a small database. Shawn Green Database Administrator Unimin Corporation - Spruce Pine [EMAIL PROTECTED] wrote on 12/12/2005 05:30:57 AM: > The main items to be stored are images and video clips but taking > advice from previous emails on this list, we will be holding these > outside MySql so > the tables are to do with loading these, manipulating them, and > keeping details on clients, customers and contacts etc. None of them > will be large. > I estimate that if the largest one exceeds 200,000 records we will be > millionaires! > > As I am not expecting to do anything radical I have started to write > the site in PHP5. > > Thanks to those who replied to my email > > Ch > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of Peter M. Groen > Sent: 12 December 2005 00:14 > To: mysql@lists.mysql.com > Subject: Re: PHP4 or PHP5? > > > On Sunday 11 December 2005 23:51, Charles Walmsley wrote: > > Dear All, > > > > > > > > I do not have much experience with PHP or MySql although I have used SQL > > quite a lot. I am going to set up a relatively small MySQL database > (circa > > 40 tables) and we are expecting a hit rate of about 40,000 visitors per > > annum mostly browsing a relatively low number of pages each. We > > plan to > > launch in March > > > >--------------------[ 8< ]------------------------------ > > Ehm.. To be blunt... 40 TABLES??? You call that small? What on earth > are you > > going to store. > > Fester > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]