General Item page is fixed
Reply
Item page is fixed
I've finally gotten the chance to address the item page. I've identified the problem query--there are several on that page--and disabled that one query. I've sent instructions to the host on how to implement the code changes. I'm locked out and can't do it myself. As soon as they do that the page should be back up but the part that shows what npcs drop the item will be blank.

New tables need to be generated to fix the performance issues but that is easier said than done.

So far nobody has complained! So thanks everyone for being patient. I was actually out of town at a conference when the problem happened.
Last edited by Maudigan on Tue Apr 30, 2013 8:54 pm; edited 1 time in total
Tue Apr 30, 2013 5:03 pm
Project Lead
Okay... the host didn't fully restore my permissions last week. This may slow me down if they don't fix it quickly.
Tue Apr 30, 2013 5:22 pm
Project Lead
The item page is restored, and the database has been refreshed.

In a test run the relevant query's time improved from 3.506838 seconds to 0.000303 seconds. I think we are out of the woods on the item page. Let me know if any results seem wonky.
Tue Apr 30, 2013 8:52 pm
Project Lead
General Item page is fixed
Reply