6000 Reached

[FuNkY_CaPrIcOrN]

Database (http://bellsouthpwp.net/F/u/FuNkY_CaPrIcOrN/database.JPG)

:) And still running pretty good.All Album Covers included also.

To a few People who said OrangeCD was not good for large Databases.....well you were wrong.

Just wanted to Comment and let you know how some large Databases are doing and what their Size are.


FC

[FuNkY_CaPrIcOrN]

Ok I do want to say she is running a little slow.But we have to remember I am useing a old 700mhz Pentium.

I have a new AMD 2600 I will be testing the Database out on later.

[Guest]

:Phaveing no problem at all am on 25487 and still no problem only if i delete album he mixed it up a little when i view to ;D
artist (overview)+artist.
he won't trhow there away in there ::)

[andrei_c]

Can you share your thoughts about database performance with these volumes of data? If there are specific features that you think are slow, I'd like to fix them.

Andrei

[pbthal]

My db is 3500 albums, full album art and AMG reviews, size is about 65 megs, no real complaints, sometimes going from band to band in grid view there is a delay, nothing major.

[FuNkY_CaPrIcOrN]

65 megs?I bet it is running a little slow.My stats are 6107 disks at 19.17 megabytes.

What you need to do is go to view , Preferences and then Imaging.Check the box that says "Store covers in external files if size exceeds".Make sure the other Box is unchecked.Now set it to 0.

Next thing go to Database and then compact.It will stor all your Art work in a seperate folder on your PC.It really helps Orange to run alot faster.

FC 8)

[JohnsonbI4]

oh god, fc is back... :'(

;)

[pheisholt]

My collection consists of 900+ CDs (=15000+ tracks) and my database file size is 11 MB.
So FuNkY_CaPrIcOrN - how have you managed to squeeze 6000 CDs into 19MB?

I have checked:
- Store covers in external files if size exceeds 32KB
- Store thumbnails in the database

[rcarljohnson]

I'm pretty sure that FC has

- Store covers in external files if size exceeds 0KB
- Store thumbnails in the database - NO ???

That will greatly reduce the DB size. He probably also has the store Thumbnails unchecked. This will result in the smallest DB size but will use an external directory to hold all of the artwork.

Bob

[pheisholt]

Hi Bob

You're probably right. I did some testing myself, and found that fine tuning these two parameters does actually reduce the DB size drastically. Here are the results of my little test:

My OCD collection stats
Total playtime............: 34:06:57:40
Total # of albums.......: 849
Total # of disks..........: 911
Total # of sets............: 50
Total # of tracks.........: 15125

Test results:
-----------------------------------------------------------------------
---(1)-------(2)-------(3)-------------(4)---------(5)---------------
-----------------------------------------------------------------------
Yes 32KB....Yes.....11,12 MB.......148,2 MB....776
Yes 32KB....No........5,12 MB.......148,2 MB....776
Yes 16KB....No........3,29 MB.......150,2 MB....860
Yes 8KB....No........2,74 MB.......150,6 MB....888
Yes 0KB....No........2,59 MB.......150,7 MB....911
-----------------------------------------------------------------------
(1) = Store images in external file if size exceeds...
(2) = Store thumbnails in database
(3) = My OCD database file (.dab) size
(4) = My covers folder size
(5) = # of files in covers folder

So setting the cover size to 0 KB would reduce an OCD collection of 6000 disks to approx. 17MB.

[rcarljohnson]

Thanks for the Info Paul!

That is a very nice comparison chart there. Very informative to anyone who has wondered how those setting affect the size of the Database.

For what it is worth, here are my DB stats at this very moment:

1050 Albums
7274 Tracks
70 Artists
DB Size 9.33 Meg

Store covers in external files if file exceeds X kb is set to 0 KB
Store Thumbnails in DB is checked

Covers folder size 7.88 Meg
327 Files in Covers folder

Bob

[Trawlerman]

[quote=cool4cools] :Phaveing no problem at all am on 25487 and still no problem only if i delete album he mixed it up a little when i view to