Description of the database and search functionality

[ErikBachmann]

I'm testing the XnViewMP search functionality since the search function in XnView is sloooow on large amounts of files (>10K) - on Windows at least.

When I open the Search window in XnViewMP (v0.64) and check the "Use database" check box - I cannot find anything in the database at all. No IPTC, no rating.

I've taken a look at Tools / Settings / Database:

• Added "Base path of your pictures"
• Ran the "Rebuild thumbnails"
• Even included the pictures path in the "Excluded/included" tab

Still nothing found in database.

In the "View" menu I've tried the "Rebuild thumbnails" and "Update database from files" - but still ...

Could anyone please describe:

• How to update the database with IPTC and other meta data?
• Where can I find the IPTC data in the database (for verification or export) ?

Best regards
{ö} Erik Bachmann

[JohnFredC]

0.64 searching "use database" fails with every example I have tried.

By "fail" I mean nothing happens: the "Searching" popup never populates.

Disabling "use database" gives results instantly.

[xnview]

What do you have in Conditions??

[JohnFredC]

I tried several different criteria. Here is a screen shot of a file size search.



MP will remain in this condition until I cancel the search.

Disabling "Use database" causes MP to display the proper results of the search.

[oops66]

0.64 searching "use database" fails with every example I have tried.
By "fail" I mean nothing happens: the "Searching" popup never populates.
Disabling "use database" gives results instantly.

Hello,
FI: Same problem here with "search IPTC keywords" and with settings...
Case sensitive = off
Use database = on
Recurse through subfolders = on

Match Any of the following conditions = on

[ErikBachmann]

Should the database search search through the Meta blob in table Images in XnView.db?? (And how do you interpret the Meta blob) ?
Or is search based on the field Label in table Tags?

Tags seems to contain some entries from IPTC keywords - but no other entries from IPTC or EXIF.

[m.Th.]

0.64 searching "use database" fails with every example I have tried.

By "fail" I mean nothing happens: the "Searching" popup never populates.

Disabling "use database" gives results instantly.

Old bug. From 0.5x IIRC.

[m.Th.]

I'm testing the XnViewMP search functionality since the search function in XnView is sloooow on large amounts of files (>10K) - on Windows at least.

The true solution is described here: http://newsgroup.xnview.com/viewtopic.php?f=60&t=28345

[xnview]

I see that you have *.*, please try by removing it

[JohnFredC]

I see that you have *.*, please try by removing it

Well, that solved the problem, though in a counter-intuitive fashion, IMO.

[m.Th.]

I see that you have *.*, please try by removing it

Well, that solved the problem, though in a counter-intuitive fashion, IMO.

Also I think that this is counter-intuitive.

Also, how can one search for the files which have eg. FileSize > 25 AND filename = '*.jpg'?

Either you'll do it through SQL (which is recommended, being much faster), either by plain-vanilla scanning is quite simple to do it.

PS: Solution available upon request, as always.

[xnview]

Yes, it seems that it's a problem with sqlite

[m.Th.]

Yes, it seems that it's a problem with sqlite

See your PM

[xnview]

Bug confirmed and will be fixed. See issue 215 for current status and details.