I have a database in which one table has 15,000,000 records and another has
50,000,000 records.
Selects work fine so long as you use an index.
You may be limited by the OS.
Regards
Quentin
> -----Original Message-----
> From: Chris Murley [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, January 12, 2001 12:54 PM
> To: [EMAIL PROTECTED]
> Subject: The scaling question?
>
>
> I know everyone on this list has discussed scaling over and over.
>
> I am only in a need of a simple anwser.
>
>
> Can mysql handle a database with 20,000,000 records?
>
> There will be several tables(about 10) each with no more that 4 columns.
>
> In each table there will be 20 million records. These tables will all be
> linked with id's.
>
> Can mysql hold up to this?
>
> If so will my queries be terribly slow??
>
> Thanks for any insight!
>
>
> -Chris
>
> -----------------------
> Christopher Murley
> Application Index
> http://www.appindex.net
> http://www.appindex.org
> -----------------------
>
>
> ---------------------------------------------------------------------
> 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
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
---------------------------------------------------------------------
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
