Archive for June 2nd, 2003
Wow! It is Query Time
For the past week we have been struggling to figure out why the database queries have been taking so long to execute for this site. Well.. We finally found our culprit. We have been logging referer info and have failed to limit it.. What this means in short is that everytime you loaded a page, it had to search atleast 500,000 records in the database. Needless to say, this slowed things down quite a bit and we sometimes had to lock people out of the site.
You should notice a HUGE increase in access time on this site from this point on. Sorry to slow everyone down for the past few weeks. We are back to normal now.
*EDIT*.. even faster now.. Added certain indexes into the database to speed up search requests.. On a mission to optimize. 
I Pity the Fool
First off… There is a new level in the Dance2 section called “HELLBEAT” and it is exactly that. I wanted to get some easier songs out for the newbies but this one found it’s way onto the server first. Arktisk (David Poore) created this punishing beat upon request from Hyrogashi. Thanks Arktisk for that crazy beat. Hyrogashi once again sends the masses running in all directions with his unstoppable barrage of arrows. This is another one of those levels that I probably won’t be able to complete for a long time.. a long long time. Good luck. Don’t forget to CLEAR that CACHE!
On a side note, I am sorry for being so silent for the last week. I have had the holidays and some crazy work hours trying to finish up projects for clients. I actually pulled a 38 hour workday over the weekend. Getting back on track with FFR today.
What would YOU like?
When you come to Xqsite.com would you like to see the most current news and notes (what you are viewing now) or would you like to be sent directly to the game?
I thought of making this a poll item but thought we could get more information and reason as to the thoughts of others out of reading/replying to the comments.
Please voice your opinion, it will count.
Cheers,
Synthlight
Hi-Score Change
I will be fixing a slight bug tonight. The top 50 hi-scores available from the main screen do not work if you exit a level and then try to view them. You can only view them when you first enter the site or when you refresh. I will see if I can get that bug out of the way.
We are fully switched to our new dedicated box and it seems like everything has propagated correctly. If you find any bugs or the piece does not load correctly for you, give me a hollar.
