Thanks for you help, can anyone tell me what the file size limit is under
windows?? win 200 or win me?
-Chris
-----------------------
Christopher Murley
Application Index
http://www.appindex.net
http://www.appindex.org
-----------------------
On Fri, 12 Jan 2001, Quentin Bennett wrote:
> 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
>
---------------------------------------------------------------------
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
