Re: Wide eyes

2005-05-23 Thread Per Jessen
Critters wrote: > Is a table with say 5,000,000+ records possible? Certainly. I've got some sideline app that's currently working it's way through about 15mill rows. I think it takes up about 3Gb diskspace for the moment. > What are the things to look out for with this amount of data? Not m

Re: Wide eyes

2005-05-23 Thread Critters
Thankyou very much, at this stage we just wanted to know it *can* be done. Thanks again -- David Scott - Original Message - From: "Jay Blanchard" <[EMAIL PROTECTED]> To: "Critters" <[EMAIL PROTECTED]>; Sent: Monday, May 23, 2005 3:39 PM Subject: R

RE: Wide eyes

2005-05-23 Thread Jay Blanchard
[snip] Is a table with say 5,000,000+ records possible? What are the things to look out for with this amount of data? Could the database be split over several database servers? Is there anywhere on the mySQL site about "huge databases"? [/snip] Yes. We have several tables with well over 100 mil

Wide eyes

2005-05-23 Thread Critters
Hi The company I work for is putting together a quote for a site, the client has wide eyes and is proposing 5,000,000 users and other large figures for elements which we intend to use MySQL for. So the questions: Is a table with say 5,000,000+ records possible? What are the things to look out