Also, a thought: if you have a huge amount of records in that table, they're probably transients or other cache material from a somewhat misbehaved plugin. A w

Also, a thought: if you have a huge amount of records in that table, they're probably transients or other cache material from a somewhat misbehaved plugin. A way to "handle" that (other than the obvious and important technique of identifying and fix whatever is creating them) is to install an in-memory caching plugin that will store transients in RAM instead of in the database.