Change font size
It is currently 2020-09-24, 10:30 am


Post a new topicPost a reply Page 1 of 1   [ 4 posts ]
Author Message
 Post subject: Database upgrades
PostPosted: 2010-09-27, 1:28 pm 
Site Admin
User avatar

Joined: 2010-09-27
Posts: 133
Migrated to database:
  • cuesheets + meta (everything as one record)
  • categories (shows)
  • users
  • HoF

Needs to be moved/completed:
  • shoutbox / requests
  • cuesheet comments
  • cuesheet tracks as separate records
  • cuesheet download links
  • download link meta (host, bitrate, filesize, etc)
  • cuesheet + their dlink downloaded history

Did I miss anything?


Top
 Profile  
 
 Post subject: Re: Database upgrades
PostPosted: 2010-09-27, 4:06 pm 
User avatar

Joined: 2010-09-27
Posts: 96
Location: Finlandia
The Performer and Title of the cues are currently stored in "search" files, so at least storing them in separate columns will reduce need for parsing when listing cues.

For DL links an info (e.g. bitrate) column would be good.

Unfortunately it's not possible to make natural order sorting in the DB, otherwise it would be possible to only fetch the cues that are shown on the front page, but I guess it's not a big overhead if only Performer and Title are fetched.


Top
 Profile  
 
 Post subject: Re: Database upgrades
PostPosted: 2010-09-28, 12:36 am 
Site Admin
User avatar

Joined: 2010-09-27
Posts: 133
if you do SELECT * FROM `cuesheets` then you'll be dealing with ~19MB array... but if we do SELECT data FROM `cuesheets` WHERE `folder` = 'asot' then its only ~2.5MB of data. Our limit is, i think, 16MB so we're safe in this case... for now at least :P


Top
 Profile  
 
 Post subject: Re: Database upgrades
PostPosted: 2014-11-14, 7:28 am 

Joined: 2014-11-14
Posts: 1
aye - thank you - I was looking for a text box - the button shall do! thanks :bashful:

_________________
You can try out our Braindumps and latest wikipedia to get high flying success in final University of California, San Francisco and RIVERBED exams. Our selftestengine is also very CISCO


Top
 Profile  
 
Display posts from previous:  Sort by  
Post a new topicPost a reply Page 1 of 1   [ 4 posts ]


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