XnView Software

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

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.

What do you have in Conditions??

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.

JohnFredC wrote: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

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.

JohnFredC wrote: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.

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

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

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

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

JohnFredC wrote:

xnview wrote: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.

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

xnview wrote:Yes, it seems that it's a problem with sqlite

See your PM

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