Hi Peter, 40 tables seems to be relatively small, I have several databases that I manage that have tables that number in the hundreds. In other databases, I have one site that has 7,500 tables. Have a look at some of the open source ERP systems around eg. Nola or similar, their tables number in the hundreds. It just needs to be managed correctly like anything else that becomes complicated. You have a set of routines and procedures and refine and stick with them.
BTW IMHO it would depend on whether you need the features of PHP5 vs 4. PHP4.4.1 is quite stable and works fine. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -----Original Message----- From: Peter M. Groen [mailto:[EMAIL PROTECTED] Sent: Monday, 12 December 2005 10:44 AM 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
