http://qs321.pair.com?node_id=455159


in reply to Re^3: DBI speed up needed on MySQL
in thread DBI speed up needed on MySQL

I suspect that the OP has inherited this database, and is providing glue between two parts of a system that he doesn't have control over. 200 columns is probably a DB design problem, but it may be Somebody Else's Problem™. The OP is likely trying to make ends meet before they move the ends again - whether they're in the right place or not.