Quote:
Originally Posted by jact
I don't know how NATS is written, but if it's anything like Carma, there are some extremely bloated and poorly (read: NOT AT ALL) optimized queries contained in TMM code. We have extremely well optimized servers thanks to Mojohost and Carma runs like a dog even on that. Hundreds of hours of investigation later, it's the queries compiled into the code....
Soooooo I dunno about that one. I'm hoping NATS doesn't suffer the same inefficiencies.
|
First thing to check would be KEY's and INDEX's and if common sense is used in the tables, next thing is to check your BIN LOGS (turn them on if they are off) to see the common queries and then have someone analyze it for you in case you are not able to do it yourself.
I don't know about CARMA, but haven't seen anything alarming on NATS before, spending hundreds of hours on debugging databases and queries seems somewhat high for the complexity TMM usually use in their databases , I hope your host didn't bill your per hour for that because then your where paying for someone to learn not to fix
