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" <[EMAIL PROTECTED]> To: "Jerry" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > 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 <[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
