Page 1 of 1

Mar 7 2012 - SQL Optimization

Posted: Wed Mar 07, 2012 7:18 pm
by Red Squirrel
I just did a quick SQL optimization update, very small change (literally 1 line of code). There should not be much noticeable difference on the UO side, as this is mostly to optimize the SQL server side/host which is also the VM host for the server. Overall the entire server as a whole should be faster. Sites that are hosted on it such as UO Gateway now respond faster.

Let me know if there are any issues that you notice.

Archived topic from AOV, old topic ID:6427, old post ID:37744

Mar 7 2012 - SQL Optimization

Posted: Wed Mar 14, 2012 9:57 pm
by Red Squirrel
I have to say this worked out fairly nicely. Seems the UOG poller is keeping up now, as before it was backlogging.

With the server being more responsive, I think I will move this site over to it some time.

Archived topic from AOV, old topic ID:6427, old post ID:37759