Author Topic: Colour class search result narrowing requires index rebuild.  (Read 8863 times)

Offline Joel Goodman

  • Full Member
  • ***
  • Posts: 105
    • View Profile
I think I'm getting caught out with database refresh requirements here and wondering whether it's unreasonable to expect different behaviour.

Here's an EG:
Search results displayed in thumbnails.
I switch colour classifications for those I want to narrow down, deselect the classes I don't want and hit the refresh button.
But the search results are not updated until I rescan the affected folders (images might be across dates over several years so I either manually note the dates of all the served images and rescan each of those or do a complete rescan) and then wait whilst, after the rescan, the search index is rebuilt with the new info (a few minutes if only a one folder but hours if several folders).

Is there a means for the database to be updated on the fly? Or a means to narrow down and select thumbnails from search results, without having to rescan and rebuild the index first? It's the sort of thing you'd be flicking through, selecting maybe a dozen from 200 results, then whittling to 6 etc, so you'd want an instant response to be practical.

TIA

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25020
    • View Profile
    • Camera Bits, Inc.
Re: Colour class search result narrowing requires index rebuild.
« Reply #1 on: June 05, 2019, 11:42:35 AM »
I think I'm getting caught out with database refresh requirements here and wondering whether it's unreasonable to expect different behaviour.

Here's an EG:
Search results displayed in thumbnails.
I switch colour classifications for those I want to narrow down, deselect the classes I don't want and hit the refresh button.
But the search results are not updated until I rescan the affected folders (images might be across dates over several years so I either manually note the dates of all the served images and rescan each of those or do a complete rescan) and then wait whilst, after the rescan, the search index is rebuilt with the new info (a few minutes if only a one folder but hours if several folders).

Is there a means for the database to be updated on the fly? Or a means to narrow down and select thumbnails from search results, without having to rescan and rebuild the index first? It's the sort of thing you'd be flicking through, selecting maybe a dozen from 200 results, then whittling to 6 etc, so you'd want an instant response to be practical.

TIA

Not sure I understand your example.  Are you changing metadata or just filtering what you want to see?

-Kirk

Offline Joel Goodman

  • Full Member
  • ***
  • Posts: 105
    • View Profile
Re: Colour class search result narrowing requires index rebuild.
« Reply #2 on: June 05, 2019, 11:57:24 AM »
Just wanting to filter within the served results using colour class.

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25020
    • View Profile
    • Camera Bits, Inc.
Re: Colour class search result narrowing requires index rebuild.
« Reply #3 on: June 05, 2019, 12:15:26 PM »
Joel,

Just wanting to filter within the served results using colour class.

No indexing needs to happen if no metadata changes are made.  Perhaps you could post some screenshots that illustrate (even better if you could annotate them) the problem you're having?  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 JPEG format screenshot(s).

Thanks,

-Kirk
« Last Edit: June 05, 2019, 01:34:48 PM by Kirk Baker »

Offline Joel Goodman

  • Full Member
  • ***
  • Posts: 105
    • View Profile
Re: Colour class search result narrowing requires index rebuild.
« Reply #4 on: June 05, 2019, 01:31:04 PM »
Thanks Kirk,
Here you go.
Image 1: all search results for a random query will all colour classes active, after I've switched a load across to cyan.
Image 3: selecting just cyan filter and hitting refresh.
Image 4: rescanning a folder with some of the images that have been switched to cyan on image 1
Image 6: refreshing results after the rescan of the folder.



Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25020
    • View Profile
    • Camera Bits, Inc.
Re: Colour class search result narrowing requires index rebuild.
« Reply #5 on: June 05, 2019, 01:40:34 PM »
Joel,

Image 1: all search results for a random query will all colour classes active, after I've switched a load across to cyan.

What does "switched a load across to cyan." mean?  What operation did you perform?

-Kirk

Offline Joel Goodman

  • Full Member
  • ***
  • Posts: 105
    • View Profile
Re: Colour class search result narrowing requires index rebuild.
« Reply #6 on: June 05, 2019, 01:50:40 PM »
Not sure whether I have better language to describe it.
I can set images to be one of 8 colour classes. I set several images to the colour class that I identify as "cyan" (as per the colour class selectors in the top right of my screen grabs), as opposed to any of the other (or no) colour class.

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25020
    • View Profile
    • Camera Bits, Inc.
Re: Colour class search result narrowing requires index rebuild.
« Reply #7 on: June 05, 2019, 02:33:13 PM »
Joel,

I can set images to be one of 8 colour classes. I set several images to the colour class that I identify as "cyan" (as per the colour class selectors in the top right of my screen grabs), as opposed to any of the other (or no) colour class.

Let me ask in a different way:

Are you only manipulating the color class filter in the upper right corner of the contact sheet window?  Or are you also changing the color classes on the actual images themselves?

-Kirk

Offline Joel Goodman

  • Full Member
  • ***
  • Posts: 105
    • View Profile
Re: Colour class search result narrowing requires index rebuild.
« Reply #8 on: June 05, 2019, 03:02:46 PM »
Both.
First I change the colour class on the images served up in the search results, then I update the colour class filter options in the top right hand corner. Then I refresh the results using the refresh button.

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25020
    • View Profile
    • Camera Bits, Inc.
Re: Colour class search result narrowing requires index rebuild.
« Reply #9 on: June 05, 2019, 04:31:21 PM »
Joel,

You should not need to re-add the images to the catalog.  I noticed in the first image that your search results images do not have green indicators on them.  Are the original images not local or have they been moved?  I noticed in the last image (after the scan to catalog) that they're now filled green which indicates that they're local.

-Kirk

Offline Joel Goodman

  • Full Member
  • ***
  • Posts: 105
    • View Profile
Re: Colour class search result narrowing requires index rebuild.
« Reply #10 on: June 05, 2019, 07:47:14 PM »
They're all stored on a NAS device.

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25020
    • View Profile
    • Camera Bits, Inc.
Re: Colour class search result narrowing requires index rebuild.
« Reply #11 on: June 05, 2019, 08:42:54 PM »
Joel,

They're all stored on a NAS device.

But was the NAS mounted and available and none of the files moved at the time of the search?

-Kirk

Offline Joel Goodman

  • Full Member
  • ***
  • Posts: 105
    • View Profile
Re: Colour class search result narrowing requires index rebuild.
« Reply #12 on: June 05, 2019, 08:50:55 PM »
The files don't move. They've been in the same location for years.
The NAS is accessed as a drive on the local network.
The changes to the colour class and refresh are taking place seconds apart.
Am I understanding your questions correctly?

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25020
    • View Profile
    • Camera Bits, Inc.
Re: Colour class search result narrowing requires index rebuild.
« Reply #13 on: June 05, 2019, 09:16:32 PM »
Joel,

The files don't move. They've been in the same location for years.
The NAS is accessed as a drive on the local network.
The changes to the colour class and refresh are taking place seconds apart.
Am I understanding your questions correctly?

Yes, I believe so.  Something definitely is not working correctly.

-Kirk