View Single Post
  #4 (permalink)  
Old 07-04-09, 06:45
mike_bike_kite mike_bike_kite is offline
vaguely human
 
Join Date: Jun 2007
Location: London
Posts: 2,517
Quote:
Originally Posted by ankur02018
8 million records
I was correct then.
I guess you mean that some tables contain 80m records rather than each record is 80m char long?
Can you give the table definition + indexes?
Can you give some example SQL that's running slowly?
How slow is slow (in seconds)?

I don't see how 80m records will even slightly affect MySQL - that is only a moderate table in database terms.

Mike
Reply With Quote