Yggdrasil Radio Discussion

Rockin' the World With Jpop and Your Requests
It is currently Thu Aug 16, 2018 3:22 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: Database cleanup
PostPosted: Thu Jan 21, 2010 8:33 pm 
Offline
Yggdrasil DJ
User avatar

Joined: Wed Jul 11, 2007 6:42 pm
Posts: 231
The database was getting unwieldy, so I trimmed it back quite a bit. There was info on 266,142 songs played and 61,131 song requests made since 2008 -- I kept data on all songs played this year to date, and requests made within the last 31 days. I also put indexes on fields in the songlist table used in website searches.

There was a scary moment when one operation took 15 minutes to complete, during which the database was so busy that the station went down.

Sadly, I had to take the "vote up / down / favorite" display out of the songinfo pages. That was taking six seconds to generate, making those pages just too darned slow.

I'll have to work out some faster way to do that.

_________________
Image


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group