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 > >
