POLL: How Many Images Are You Cataloging in Photo Supreme?

How many images do you have in your catalog?

less than 5,000 images
5
5%
between 5,000 and 10,000 images
3
3%
between 10,000 and 20,000 images
17
17%
between 20,000 and 30,000 images
14
14%
between 30,000 and 50,000 images
15
15%
between 50,000 and 100,000 images
22
22%
between 100,000 and 200,000 images
17
17%
between 200,000 and 500,000 images
4
4%
more than 500,000 images
2
2%
 
Total votes: 99

danieljcox
Posts: 22
Joined: 23 Apr 14 16:07

POLL: How Many Images Are You Cataloging in Photo Supreme?

Post by danieljcox » 23 Apr 14 17:12

Hoping to hear from folks cataloging large number of images within Photo Supreme. Is anyone imported 400,000 photo or more?

Hert
Posts: 20310
Joined: 13 Sep 03 7:24

Re: How Many Images Are You Cataloging in Photo Supreme?

Post by Hert » 23 Apr 14 22:23

I've changed this into a poll...
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

User avatar
lippe
Posts: 1697
Joined: 12 Aug 06 12:26
Location: Wondelgem (Belgium)

Re: POLL: How Many Images Are You Cataloging in Photo Suprem

Post by lippe » 24 Apr 14 8:15

I use multiple catalogs and keep the size rather limited for performance reasons. My current hardware seems with the 10000 to 20000 range in balance.
Photo Supreme V3, LR6, FPV, PSE14 - vaio i5 @ 2.5GHz + 8GB , 850 EVO 500GB - WD 1TB - Windows 10 Pro 64 bits- DS216play - EOS 600D

danieljcox
Posts: 22
Joined: 23 Apr 14 16:07

Re: POLL: How Many Images Are You Cataloging in Photo Suprem

Post by danieljcox » 26 Apr 14 21:32

lippe wrote:I use multiple catalogs and keep the size rather limited for performance reasons. My current hardware seems with the 10000 to 20000 range in balance.
Lippe, can you search across those individual catalogs? I'm hoping numerous catalogs are not necessary since the power of a computer is supposed to be the ability to handle massive amounts of data. That's the beauty of an all in one database mangement tool. I'm planning to Import my entire digital image database of 500,000 images and I'm truly hopeful Photo Supere will handle it. Will let you know. So far I'm loving what I see with a test catalog of 15,000 images.

DirkS
moderator
Posts: 5228
Joined: 25 May 08 14:28
Location: Essex, UK

Re: POLL: How Many Images Are You Cataloging in Photo Suprem

Post by DirkS » 27 Apr 14 1:04

can you search across those individual catalogs?
No, you can only search within 1 catalog / database.

Gr.
Dirk.
Problems searching the forum? Try Google Site Search by adding 'site:forum.idimager.com' to a standard Google search.

Preston B
Posts: 390
Joined: 24 Feb 10 19:01
Location: Columbia, CA

Re: POLL: How Many Images Are You Cataloging in Photo Suprem

Post by Preston B » 28 Apr 14 23:21

I have a single catalog with about 3700 images. Most of these are various versions (web and print files) derived from 4x5 scanned film, with a smattering of digital camera images.

It looks like I'm the low man on the totem pole, so far. :D

--P
Preston Birdwell
Columbia, CA

Photo Supreme on Puget Systems Obsidian: Win 10-64 bit Intel i5Quad Core 3.3Ghz 32GB RAM, and Puget Systems Traverse Laptop. Chamonix 4x5 and Nikon D-7100.

Please visit my web site at www.gildedmoon.com

andy@damroundup.com
Posts: 983
Joined: 13 Apr 08 19:54
Location: Boston, MA USA

Re: POLL: How Many Images Are You Cataloging in Photo Suprem

Post by andy@damroundup.com » 02 May 14 13:45

I'm hovering right around 70,000 images at the moment... cruising along just fine. :)
Check out our detailed DAM reviews at http://www.DAMRoundup.com
Custom designed books for publication or personal enjoyment - http://www.JingotheCat.com

HaraldE
Posts: 377
Joined: 29 Apr 07 22:30
Location: Bålsta, Sweden

Re: POLL: How Many Images Are You Cataloging in Photo Suprem

Post by HaraldE » 03 May 14 0:16

Have around 84 k images and all is fine. No versions but a lot of Collections in a few Portfolios

Regards, Harald

space
Posts: 68
Joined: 06 Feb 08 5:47
Location: Hong Kong
Contact:

Re: POLL: How Many Images Are You Cataloging in Photo Suprem

Post by space » 19 May 14 18:08

Have 112,000+ images in my digital archive.

Sometime back had some significant issues with my thumbnail database. This had "swollen" up to 25 GB. While trying to run the compacting routine continually got these database error messages. Trashed the thumbs DB and did a rebuild. Its now at a respectable 13 GB. Suspect there may have been some "corrupted" images in there amongst some other "rubbish". Anyway things seem to be running sweet on my system. Now running PS off a WIN 8.1 laptop - i7 + 8 GB RAM and regular HDD.

HCS
Posts: 147
Joined: 19 Feb 14 22:08

Re: POLL: How Many Images Are You Cataloging in Photo Suprem

Post by HCS » 06 Nov 14 14:04

Did vote in the poll, but never posted. I'm currently hovering around 65K raw images with quite a bunch of original jpegs and a stash of derivatives, together probably around 15-20K.

Running the postgres version on a MacPro with 48Gb and SSD for database and RAID0 for images. And that, obviously, runs fine :-)

rab108
Posts: 12
Joined: 12 Nov 14 12:48

Re: POLL: How Many Images Are You Cataloging in Photo Suprem

Post by rab108 » 12 Nov 14 12:52

I am new to PS and am interested in cataloging over 400k (eventually) images.

HCS
Posts: 147
Joined: 19 Feb 14 22:08

Re: POLL: How Many Images Are You Cataloging in Photo Suprem

Post by HCS » 14 Nov 14 19:51

rab108 wrote:I am new to PS and am interested in cataloging over 400k (eventually) images.
I don't see why that should be a problem, provided you use the server version (i'm not sure how far the standalone (=sqlite) version would take you) and given the right server sizing.

However, write an email to the support address and ask, i'm pretty sure they will give you guidance.

lmogens
Posts: 4
Joined: 14 Dec 14 10:20

Re: POLL: How Many Images Are You Cataloging in Photo Suprem

Post by lmogens » 14 Dec 14 11:00

There are other cataloging systems out there using SQLite, such as Lightroom 5 and Capture One Pro 8.

Some users of Lightroom are happily running +500k catalogs, while Capture One users much sooner start to suffer performancewise.

This would suggest that there are other more important factors than the DBMS, such as the entire implementation of the cataloging software, and the individual database design. Looking at some simple figures is quite telling :

Capture One 8: 20 tables, 19 indexes
Lightroom 5: 96 tables, 221 indexes
Photo Supreme 2: 47 tables, 158 indexes

Also, considering that relational database management systems is a well-established, mature technology there is no reason to expect any noticable performance degradation with size from the DBMS itself, in this case SQLite. There may be hard proof to the contrary out there though.

HCS
Posts: 147
Joined: 19 Feb 14 22:08

Re: POLL: How Many Images Are You Cataloging in Photo Suprem

Post by HCS » 18 Dec 14 16:19

lmogens wrote:There are other cataloging systems out there using SQLite, such as Lightroom 5 and Capture One Pro 8.

Some users of Lightroom are happily running +500k catalogs, while Capture One users much sooner start to suffer performancewise.

This would suggest that there are other more important factors than the DBMS, such as the entire implementation of the cataloging software, and the individual database design. Looking at some simple figures is quite telling :

Capture One 8: 20 tables, 19 indexes
Lightroom 5: 96 tables, 221 indexes
Photo Supreme 2: 47 tables, 158 indexes

Also, considering that relational database management systems is a well-established, mature technology there is no reason to expect any noticable performance degradation with size from the DBMS itself, in this case SQLite. There may be hard proof to the contrary out there though.
I understand your reply is not a direct response to mine above, but to a certain extend you address topics i address as well.

What i'm saying (or rather: am trying to say) is that there may be nothing wrong with SQLite as such, having a proper enterprise scale database for you catalog will guarantee that it will not cringe under larger loads. 400K+ records is becoming big for SQLite (the internet can be searched for literature on that) but it means absolutely nothing to a DB like Postgresql, which is intended for millions+ records.

So, i think that Adobe got the tuning of their LR database down to a good level and Phase One apparently haven't for the CO8 database. This doesn't mean that the larger database wouldn't do better with ever growing load. I do know that with my DB size the standalone version of PSU on a not too shabby system was sometimes giving me strange latency behaviour. I chose the "easy" way out.

NassauBoy
Posts: 39
Joined: 24 Jan 16 19:20

Re: POLL: How Many Images Are You Cataloging in Photo Supreme?

Post by NassauBoy » 16 Feb 16 7:04

Voted in the 50K - 100K and currently at 80K.
So far Im happy with performance (Just wish the browsing view was faster)
Cataloging is quick, easy and love I can write back the labels to the raw file.
Late 2012 27" iMac 3.4Ghz i7: 32GB Ram: Internal SSD: External Promise R4 Thunderbolt 16TB Raid 5 (all Data)

Post Reply