Hi, does anyone have any tips as to how a local Umbraco install to a remote database can be sped up ? Connections via SQL Management studio to the remote server are fine, but from local IIS (using same connection details, same packet sizes etc) are very sluggish.
Does anyone else develop against a remote db ?
TIA,
Hendy
Hendy -
We had a client use a remote MySQL instance (at Amazon EC2) and didn't notice any significant latency for DB-specific actions. I'd expect MS SQL to perform as good or better. The likely suspect is a firewall or routing issue, IMO.
Can you do a trace to see if you're dropping connections that have to be re-established?
-Paul
Hi Paul,
Thanks for the suggestion. I'm using SQL Express so don't have the profiler tool, but have used wireshark to have a quick look at the traffic - lots of "Reassembled PDU"... and then lots of TDS query / response packets. Not sure what to try next !
TIA,Hendy