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]

Reply via email to