Author Topic: scroll a milion  (Read 884 times)

Offline baila71

  • Newcomer
  • *
  • Posts: 35
    • View Profile
scroll a milion
« on: November 04, 2024, 01:43:16 PM »
Hi, I have read that PM plus Scroll a Million Photos without a pause. If I have a data base with 1,5 million of photos, it is work too? And with 2 million?
« Last Edit: November 08, 2024, 01:15:30 AM by baila71 »

Online Mick O (Camera Bits)

  • Camera Bits Staff
  • Hero Member
  • *****
  • Posts: 553
    • View Profile
    • Camera Bits
Re: scroll a milion
« Reply #1 on: November 04, 2024, 04:53:43 PM »
There can be a lot of factors in performance. I would suggest you use the Free Trial to give it a try to see how it performs on your system.

Mick
Mick O
Camera Bits

Offline baila71

  • Newcomer
  • *
  • Posts: 35
    • View Profile
Re: scroll a milion
« Reply #2 on: November 07, 2024, 03:27:24 AM »
Can I create a catalog from my NAS thunderbolt??

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25007
    • View Profile
    • Camera Bits, Inc.
Re: scroll a milion
« Reply #3 on: November 07, 2024, 06:56:45 AM »
Can I create a catalog from my NAS thunderbolt??

Yes, but performance will be poor when the NAS is online.  Performance will be excellent when the NAS is not online but you won't be able to edit the metadata of your files.  You would be able to search/find images and where they're located while the NAS is offline and the performance will be excellent.  But when the NAS is online, viewing the images will be slow due to the poor random-access performance of NAS units.  The catalog system will access the real files when the files are available (like when your NAS is online) for gathering metadata and rendering thumbnails and previews.  When your NAS is offline, proxy images will be used for thumbnails and previews, and metadata will come from the catalog, but access is read-only in this case.

-Kirk

Offline baila71

  • Newcomer
  • *
  • Posts: 35
    • View Profile
Re: scroll a milion
« Reply #4 on: November 07, 2024, 10:01:39 AM »
Many thanks Kirk. I wrote to you back in 2009. I would like to ask another thing because I am thinking of buying PMP and I am doing some tests with the free one month version. I did SCAN TO CATALOG as per the attached photo, but if I search for an image (among the million and a half that I fed it) I can't find it. In the video that you posted, everything seems easy but then I can't continue. Is there another video that can explain the search?

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25007
    • View Profile
    • Camera Bits, Inc.
Re: scroll a milion
« Reply #5 on: November 07, 2024, 10:27:05 AM »
You've chosen a case-sensitive search.  Do your images really have the words you're searching for (SPORT, PAVAROTTI) in all upper-case letters?

If you don't know the case of the words in your metadata, don't use a case-sensitive search.

That may help.

-Kirk

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25007
    • View Profile
    • Camera Bits, Inc.
Re: scroll a milion
« Reply #6 on: November 07, 2024, 10:28:56 AM »
Also, you're choosing to only search through the items in your contact sheet from a previous search (you're refining a search).  Is that what you really want to do?  Or do you want to search the entire catalog?  If you want to search the entire catalog, then uncheck the "Only Search Contact Sheet Items" checkbox.

This also may help.

-Kirk

Offline baila71

  • Newcomer
  • *
  • Posts: 35
    • View Profile
Re: scroll a milion
« Reply #7 on: November 08, 2024, 01:15:02 AM »
Thanks Kirk for the quick reply. I followed your advice but couldn't resolve the issue. Could it be that the catalog is not ready yet? PAVAROTTI it is wrote both upper-case letters and no! The catalog contains over 1.5 million photos and hundreds of folders.
Alessandro

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25007
    • View Profile
    • Camera Bits, Inc.
Re: scroll a milion
« Reply #8 on: November 08, 2024, 10:19:49 AM »
Alessandro,

Thanks Kirk for the quick reply. I followed your advice but couldn't resolve the issue. Could it be that the catalog is not ready yet? PAVAROTTI it is wrote both upper-case letters and no! The catalog contains over 1.5 million photos and hundreds of folders.

If the images haven't made it into the catalog database yet, then searches won't find them.  If the fields containing the word you're searching for are not indexed by the Catalog system, they won't be found either.

Also, is there a reason you searched with a trailing semi-colon in this instance?

-Kirk

Offline baila71

  • Newcomer
  • *
  • Posts: 35
    • View Profile
Re: scroll a milion
« Reply #9 on: November 12, 2024, 01:01:56 PM »
From the examples as attached, I thought it was necessary for the research purposes.
I'm really sorry, but I can't get it to work even though I follow the instructions in the YouTube video to the letter. In this week's tests, and I only have two left before the end of the trial period, I can't even see the search preview images anymore. And even though I entered the file name correctly in the "search" field, it finds only one file. Is there a tutorial that can help me more? I know I'm the one who's doing it wrong, but I just can't get it to work.

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25007
    • View Profile
    • Camera Bits, Inc.
Re: scroll a milion
« Reply #10 on: November 12, 2024, 02:40:19 PM »
From the examples as attached, I thought it was necessary for the research purposes.
I'm really sorry, but I can't get it to work even though I follow the instructions in the YouTube video to the letter. In this week's tests, and I only have two left before the end of the trial period, I can't even see the search preview images anymore. And even though I entered the file name correctly in the "search" field, it finds only one file. Is there a tutorial that can help me more? I know I'm the one who's doing it wrong, but I just can't get it to work.

Can you share with me a few images that contain the metadata that you want to search for?

Use the 'Attachments and other options' link when you're composing your reply to this message and there you'll be able to upload your files.

Thanks,

-Kirk

Offline baila71

  • Newcomer
  • *
  • Posts: 35
    • View Profile
Re: scroll a milion
« Reply #11 on: Yesterday at 05:01:43 AM »
this is an example. is the search only on IPTC fields or also the file name?

Offline baila71

  • Newcomer
  • *
  • Posts: 35
    • View Profile
Re: scroll a milion
« Reply #12 on: Yesterday at 08:04:24 AM »
now is perfect!!! I can't understand how it's possible.... I did the same procedure on the entire archive, always in the NAS exactly like this Pavarotti folder, but with the entire archive it didn't work. Is there a limit to the number of files to insert into the database? now I see both the thumbnails and the search

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25007
    • View Profile
    • Camera Bits, Inc.
Re: scroll a milion
« Reply #13 on: Yesterday at 09:08:27 AM »
now is perfect!!! I can't understand how it's possible.... I did the same procedure on the entire archive, always in the NAS exactly like this Pavarotti folder, but with the entire archive it didn't work. Is there a limit to the number of files to insert into the database?

No, no limits enforced.  There's probably some limit in SQLite for how many rows can be in a table, but I doubt anyone has that many images.

I added your two images to one of my catalogs and searching for PAVAROTTI found them both immediately.  If they're in the catalog that you have set to Search, they should show up with a search for PAVAROTTI.

-Kirk

Offline baila71

  • Newcomer
  • *
  • Posts: 35
    • View Profile
Re: scroll a milion
« Reply #14 on: Yesterday at 09:38:39 AM »
Thanks Kirk for your kind and quick reply. I would proceed in this way: in these days I will do some more tests and at the end of the trial month, I will buy PMP because it is the best program in the world. Now that I have finally solved the NAS problem, I would finally like to work and archive without waiting for transfers over the network. The new QNAP NAS is connected both via network and Thunderbolt. If I should have problems with adding all my images (as already said there are over 1.5 million) to the catalog, I will write to you asking for help. Thank you very much.
Alessandro