Hello,
I would recomend getting a good book that covers "Database Normalization,"
this has to do with database design theories, etc.
Or just look for a good book on "Database Design".
----- Original Message -----
From: SED <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 20, 2001 10:56 AM
Subject: Is any limit on how many tables one database can have?
> Hi,
>
> I'm designing a database and I was wandering which one is better:
>
> A) 1000 tables (e.g. 10,000 rows each) in one database
>
> or
>
> B) One table with (e.g. 10,000,000 rows) and each group with special ID
(in
> one extra column)
>
>
> And if I need to have many tables in one database, is any limit on how
many
> tables one database can have?
>
> Regards,
> Sumarlidi Einar Dadason
>
> SED - Graphic Design
>
> ------------------------------------------
> Phone: (+354) 4615501
> Mobile: (+354) 8960376
> Fax: (+354) 4615503
> E-mail: [EMAIL PROTECTED]
> Homepage: www.sed.is <- New Homepage!
> ------------------------------------------
>
>
> ---------------------------------------------------------------------
> 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
>
>
---------------------------------------------------------------------
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