It’s been a rough one, too. The short of it is: I’m still locked out.
<tech talk to follow!>
The long-term ramifications are more troubling, though. In the development cycle, some things work, some things don’t work. That’s the whole point. Find what works best. Currently, the WARdrobe works well how it is now. Every time you view an item, the database is called and a few sets of data are returned. You have the base stats, the classes that can use it, the item set information and the bonuses. That method works great when you’re pulling one item at a time.
Flash forward to one of my initiatives though: Off-site Tooltips (this was called “Syndication” by WARdb). Say you’re on a page at WHA and there are 20 items linked. Do you sit there and wait for The WARdrobe to do 20 database calls to load those items up before returning the data to WHA? That could get a bit clunky over time. The option at that point is to load up everything before hand and stick it in a cache. That works well actually. I’ve been experimenting on how to do that. The current version isn’t pretty though. It takes roughly 57 minutes to load up all 17,000 items in the database. Ouch.
That’s where I was starting to get creative. I was trying to find some way to speed that up. I’m still pretty upset that all it took was one errant SQL query to have my entire account shut off, and that even when it was re-enabled, they decided to shut it off again. It’s even worse that it’s almost been 24 hours, and they STILL haven’t gotten it back online. My followup calls to support haven’t helped, either.
And now back to searching for a web-host again. I hate this part of the game.