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
-
Red Squirrel
- Posts: 29193
- Joined: Wed Dec 18, 2002 12:14 am
- Location: Northern Ontario
- Contact:
Mar 7 2012 - SQL Optimization
Honk if you love Jesus, text if you want to meet Him!
-
Red Squirrel
- Posts: 29193
- Joined: Wed Dec 18, 2002 12:14 am
- Location: Northern Ontario
- Contact:
Mar 7 2012 - SQL Optimization
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
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
Honk if you love Jesus, text if you want to meet Him!