Auction House Slow

Post Reply
daftchops
Posts: 7
Joined: Tue Jun 23, 2015 7:38 pm

Auction House Slow

Post by daftchops » Fri Jul 24, 2015 7:10 pm

I started a small private server about a month ago, and everything is working great except the speed of the Auction house. It seems to take 6-10 seconds to start showing items, some players say it times out constantly. I've recompiled and checked my settings, but have the same issue. Is this normal Auction house behavior?

I have the auction house stocked, everything at 20 items. I removed all 76+ gear and spells, but the database queries quickly so I don't think that is the issue.

My server is in a hosted enviroment on dedicated 50d/50u fiber. It's on Server 2008, Double Intel Xeon Quad Core Processors, 32Gb of Ram, and 15k Cheetah Drives.

Anyone have any tips on how I can increase the speed?

Thanks for any help in advance.

User avatar
kjLotus
Special Guest
Posts: 1813
Joined: Sun Jul 22, 2012 2:16 pm

Re: Auction House Slow

Post by kjLotus » Fri Jul 24, 2015 7:58 pm

you can try some profiling to see what's taking long, but also compiling in release would help for sure if you're doing it in debug

daftchops
Posts: 7
Joined: Tue Jun 23, 2015 7:38 pm

Re: Auction House Slow

Post by daftchops » Fri Jul 31, 2015 9:22 am

I resolved this, I had my query cache too high in MySQL and was causing problems.

Post Reply