I’m very impressed with DH’s features after just having moved across, the way it’s so configurable is great. But I got a nasty shock when I started running my scripts and found they were taking hundreds of times longer than they do on my development server, or my previous server.
The main reason is, I think, because mysql is on machine separate to the web server, and the pings times to and from is ~5ms. In a heavily DB reliable script 5ms/query adds up very quickly.
I expect this has come up before, does anyone have any suggestions about what to do? I’ve enabled client compression, but it hasn’t made any real difference.