I have multiple databases running tables with thousands of records in them. Some of my tables have as many as 130 million records in them. Memberships and patient data can easily run from thousands to tens of thousands of records. If you are looking into things like DNA/Genome mapping, you can easily run into billions of records.
J.R. -----Original Message----- From: Chris W. Parker [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 3:41 PM To: [EMAIL PROTECTED] Subject: OT: table size WAS RE: optimizing database Razor Fish <mailto:[EMAIL PROTECTED]> on Thursday, October 21, 2004 3:19 PM said: > i need consulting help for optimizing a database with > 1.2 million records to handle 3-4 million hits a day. this is going to be a 'duh' question on my part but i just had to ask anyway. my largest table probably has 700 records in it. what the heck kind of data is being stored where it reaches the millions (or more)? chris. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]