iamvela - 8:23 pm on Apr 14, 2009 (gmt 0)

Yeah we're not even using the medium blob column in any of the queries... I jut showed SELECT * to make the point. In actuality we do list the columns explicitly.

All operations on that table are HORRIBLY slow, even going to (as in browse) to the last page of the OFFENDING_TABLE in phpMyAdmin.

We have not done any partitioning (horizontal or vertical). That seems like the only other thing that I can think of.. and will spend some time to educate myself on that.

Or, just go to flat files and put all these mediumblobs as files.

Thanks for your inputs. Would welcome any ideas?

Regards,
--