> Have you tried Repair table or if InnoDB > ALTER TABLE ENGINE=InnoDB; > > Sometimes I've noticed after a restore or after adding lots of rows > performance is slow. REPAIR or the ALTER TABLE fixes it.
I'll try that. Thanks. What's curious is that I've got one backup I can restore and have fine performance and another, later backup that I can restore and get crappy performance. I can switch back and forth all day long with quite consistent results. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
