Re: Rows

["Jerry" <suppressed>]

I've gone over 60 million (per table and there are 4 of them) , had the
indexes sorted and it was a fast machine.

4 reference tables (foreign keys) then a counter which made a massive hash.

I'm starting to run into system and hard ware problems, more like open
files/inodes/through put, opposed to MySQL limits.

Which is nice..... :)


Cheers
 ---------------------
 Jerry @
 MetalCat.Net
 ---------------------

 SQL

----- Original Message -----
From: "MySQL List" <suppressed>
To: "Jerry" <suppressed>
Sent: Friday, February 14, 2003 9:51 PM
Subject: Re: Rows


> Uhm, would that even be possible? that is one billion rows.
> I think that would take forever to search through! What do you think?
>
> I'm building an affiliate program, and I'm worried about the impressions,
> clicks and sales
> table getting too big, but shoot, if it could hold a few million with no
> problem, then
> I probably don't have to worry :o), or should I?
>
>
> Richard.
>
>
>
> ----- Original Message -----
> From: "Jerry" <suppressed>
> To: <suppressed>
> Sent: Friday, February 14, 2003 3:23 PM
> Subject: Rows
>
>
> > Hi,
> >
> >  Any one gone over 1000 million rows ? or any where near ?
> >
> >  Pref. in ver 4+ with a MyISAM table.
> >
> >
> >  Cheers
> >  ---------------------
> >  Jerry @
> >  MetalCat.Net
> >  ---------------------
> >
> >  SQL
> >
> > ---------------------------------------------------------------------
> > 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 <suppressed>
> > To unsubscribe, e-mail
<suppressed>
> > 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 <suppressed>
To unsubscribe, e-mail <suppressed>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php