Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Hendy Racher 863 posts 3849 karma points MVP 2x admin c-trib
    Jul 02, 2009 @ 19:06
    Hendy Racher
    0

    Remote Database Speed

    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

    Copy Link
  • Paul Sterling 718 posts 1534 karma points MVP 9x admin c-trib
    Jul 03, 2009 @ 00:15
    Paul Sterling
    0

    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

    Copy Link
  • Hendy Racher 863 posts 3849 karma points MVP 2x admin c-trib
    Jul 04, 2009 @ 11:49
    Hendy Racher
    0

    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

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft