Thumbnail database size

paulgul
Posts: 11
Joined: 11 May 10 16:59

Thumbnail database size

Post by paulgul » 03 Nov 12 18:00

After some thought I have decided to give PS a try (already a idimager user). As a test I have just imported a series of folders that contain jpg's, the total size of the folders is just over 4Gb. I'm rather surprised to see the thumbnail database size is practically the same at just over 4Gb, this seems rather large, have I missed something, is there an option to save thumbnails at a reduced quality to save space.
I tried the same group of folders with ACDSee6 and the total database size (including thumbnails) is around 0.6Gb.
Anyone else noticed this?
Paul

Lars
Posts: 65
Joined: 13 Nov 09 6:44
Location: EU

Re: Thumbnail database size

Post by Lars » 04 Nov 12 6:53

paulgul wrote:After some thought I have decided to give PS a try (already a idimager user). As a test I have just imported a series of folders that contain jpg's, the total size of the folders is just over 4Gb. I'm rather surprised to see the thumbnail database size is practically the same at just over 4Gb, this seems rather large, have I missed something, is there an option to save thumbnails at a reduced quality to save space.
I tried the same group of folders with ACDSee6 and the total database size (including thumbnails) is around 0.6Gb.
Anyone else noticed this?
Paul
PS also stores previews which of course takes up a lot more space than the thumbnails alone
W7/64bit, IDimager V5 ProSL

paulgul
Posts: 11
Joined: 11 May 10 16:59

Re: Thumbnail database size

Post by paulgul » 04 Nov 12 9:04

Are these previews optional? if so how do I prevent them or turn them off.

Mike Buckley
Posts: 1194
Joined: 10 Jul 08 14:18

Re: Thumbnail database size

Post by Mike Buckley » 04 Nov 12 14:33

paulgul wrote:Are these previews optional?
Yikes! I just realized that previews apparently are not optional. If I'm right about that, how does one review a RAW file or its embedded JPEG at 100% to critique sharpness?

jstartin
Posts: 401
Joined: 23 Aug 06 13:47
Location: UK

Re: Thumbnail database size

Post by jstartin » 04 Nov 12 15:49

Mike Buckley wrote:
paulgul wrote:Are these previews optional?
Yikes! I just realized that previews apparently are not optional. If I'm right about that, how does one review a RAW file or its embedded JPEG at 100% to critique sharpness?
The stored previews are not optional. There is an options item to "load full size images" for the embedded and the full screen "previewer". For raw it requires waiting a bit while dcraw does its demosaicing stuff, naturally. The option persists for the "session", but defaults to off for each invocation of PSU. You can't get full size in the light table.
Attachments
PSU show full size.png
PSU show full size.png (311.85 KiB) Viewed 5718 times
Jim (Photo Supreme: AMD Quad-Core A8-5500 Accelerated Processor 3.2 GHz; internal AMD Radeon™ HD7560D; 4GB DDR3 SDRAM; Win10x64)

Mike Buckley
Posts: 1194
Joined: 10 Jul 08 14:18

Re: Thumbnail database size

Post by Mike Buckley » 04 Nov 12 15:55

Thanks, Jim. I now remember seeing that capability being discussed and had completely forgotten about it. By the way, that sound you just heard was a big sigh of relief coming from me.

paulgul
Posts: 11
Joined: 11 May 10 16:59

Re: Thumbnail database size

Post by paulgul » 04 Nov 12 16:27

So from what I understand then there is no way to reduce the database size. It just seems rather odd that the database is effectively doubling the amount of disk space required by the images. If this is so, then I'm afraid this program is not for me, I have around 120Gb of images to catalogue and will finish up requiring 240Gb of disk space.

weidmic
moderator
Posts: 834
Joined: 04 Dec 06 22:21

Re: Thumbnail database size

Post by weidmic » 04 Nov 12 17:27

Paul,

you can change the size of the DB!
It's possible to change the preview size to a value between 640 and 1680 pixels in predefined steps.
After you have set the preview size, you need to build the thumbs and previews again. (don't know if it is necessary to compact the Thumbnail DB afterwards)
As bigger the preview size as bigger the DB!

HTH
Michael
PSUServer 5.x, PostgreSQL 10.x
My homepage http://www.michaelweidner.com
PSU Tips and Tricks http://www.michaelweidner.com/WP/psu/

paulgul
Posts: 11
Joined: 11 May 10 16:59

Re: Thumbnail database size

Post by paulgul » 04 Nov 12 18:23

weidmic wrote:Paul,


It's possible to change the preview size to a value between 640 and 1680 pixels in predefined steps.

HTH
Michael
Must admit I didn't see that option :oops:
I've rebuilt the Db at 640px and the size has come down to 1.6Gb, I still consider this to be rather large for 4Gb worth of images.
Could someone explain why previews of jpg images are required when the original image is online, just seems a case of duplication.
Paul

Mike Buckley
Posts: 1194
Joined: 10 Jul 08 14:18

Re: Thumbnail database size

Post by Mike Buckley » 04 Nov 12 18:29

paulgul wrote:Could someone explain why previews of jpg images are required when the original image is online, just seems a case of duplication.
The previews are most beneficial when reviewing RAW files, as displaying the preview is much faster than rendering the RAW data. You're right that previews are not particularly beneficial when viewing only online JPEGs, though my guess even then is that calling the preview from the database is faster than calling the physical image file, especially a full-size image, from the hard disk. It's the developer's choice to design the software so previews are built with no option not to build them.

weidmic
moderator
Posts: 834
Joined: 04 Dec 06 22:21

Re: Thumbnail database size

Post by weidmic » 04 Nov 12 18:54

I've rebuilt the Db at 640px and the size has come down to 1.6Gb
Right, it sounds a lot... (maybe :) ) You didn't tell us how many pictures you have cataloged!
Did you compact the thumbs DB afterwards?

Cheers,
Michael
PSUServer 5.x, PostgreSQL 10.x
My homepage http://www.michaelweidner.com
PSU Tips and Tricks http://www.michaelweidner.com/WP/psu/

paulgul
Posts: 11
Joined: 11 May 10 16:59

Re: Thumbnail database size

Post by paulgul » 04 Nov 12 19:13

A total of 13600 images. I thought it would be easier to create a new catalogue so I assume there was no need to compact.
But going back to my original post I used ACDSee to catalogue the same batch of images and its Db was only around 0.6Gb - It does save previews but I'm not sure what size, the program is set on auto size so guessing they are probably small.

weidmic
moderator
Posts: 834
Joined: 04 Dec 06 22:21

Re: Thumbnail database size

Post by weidmic » 04 Nov 12 19:27

Paul,
I thought it would be easier to create a new catalogue so I assume there was no need to compact.
Absolutely! A new catalog should not need to be compacted...

Back the the amount of images:
14.000 images and only 4GB of space looks like the images are rather small.
If my calculations are correct your average image is around than 0.3 MB.

With very small images the advantage of having "previews" is very small...
But today, most pictures are much bigger than that - and as bigger the images in your catalog as bigger is the advantage of having previews saved in a database!

Hope you get the point of what I am trying to say.

Cheers,
Michael
PSUServer 5.x, PostgreSQL 10.x
My homepage http://www.michaelweidner.com
PSU Tips and Tricks http://www.michaelweidner.com/WP/psu/

Mike Buckley
Posts: 1194
Joined: 10 Jul 08 14:18

Re: Thumbnail database size

Post by Mike Buckley » 04 Nov 12 19:37

weidmic wrote:as bigger the images in your catalog as bigger is the advantage of having previews saved in a database!
When we're referring only to original images that are JPEGs, I see no significant advantage to having previews stored in the database. I especially see no advantage that merits the extra storage space that is required and the time that is required to build the previews and store them.

paulgul
Posts: 11
Joined: 11 May 10 16:59

Re: Thumbnail database size

Post by paulgul » 04 Nov 12 22:09

weidmic wrote: If my calculations are correct your average image is around than 0.3 MB.
Cheers,
Michael
Yes, you're correct about the size, these are not modern camera images, these were collected some years ago and arranged in "buckets" of around 4GB when backups were performed on dvd's
Perhaps the designers of the software will one day give users the option of not having previews - we live in hope :)

Post Reply