Anmelden:     


Forum: General Discussion

Topic: Separate databases

Dieses Thema ist veraltet und kann veraltete oder falsche Informationen enthalten.

Maybe this is pointless, but I have not found a discussion to dispute it so here goes:

Right now, I am undergoing the tedious task of moving all of my karaoke files to a separate partition on the same external hard drive so now I have a partition called Karaoke (K:).

My reason for this insanity (or maybe genius) is because I have so many files for karaoke AND MP3 that I would like to keep the databases separate. For example, when I am playing in the club and doing non-karaoke related stuff, I would hate to have the entire database crash (yes, I know, I can save it daily to have a backup) because there were two many files in one database.

I don't know if there is a limit, if it even matters whether I keep them all in the same directory or if splitting them up will help, but I figured it couldn't hurt.

Is having separate databases on the same physical drive but separate partitions even worth it? I will have my (E:) for music and (K:) for karaoke, and therefore have two databases which in order to maintain and keep them clean, I've noticed a bigger lag in the time it takes to check the databases under the browser option.

Any opinions? Praise? Ridicule?
 

geposted Tue 28 Jun 11 @ 7:59 am
No, there is a mothod to your madness and its purdent to do it this way, I have three drives, Int=Audio, E:\external=video and F:\external=Karaoke,,backups are easy and organized...Make sure all your drives are 7200rpm for faster operation..

I would buy another ext. drive and move the karaoke files to the new one..

Good Luck,

Joey....
 

Joey,

Thanks for the feedback, I have a WD My Book 3 TB drive. With 112,000 karaoke files and another 60,000 mp3 files, I figured the database might be too large (at the time I had not scanned even a 3rd of the music and the database file was at least 70 MB.

I took a portion of that drive and made a (with assigned letter) F:\Karaoke partition, 500 GB, 395 GB used. Now it accesses two databases, problem is, when I added them to the search database, for whatever reason it says it's on the C: when I look in the browser tab. I click on Check the database and returns with 60K karaoke files on the C: and 50K on the K:\Karaoke one, so I removed them all, am adding them again, hopefully that works. At any rate, everything seems to run smoother, including searches so we will see
 

Those large drive are not known for fast access, I woold use the WD for backing up all my media and purchase a G-Tech or Glyph drive very reliable and fast, not cheap, but cheap could be expensive...

Good Luck,

Joey...
 



(Alte Themen und Foren werden automatisch geschlossen)