Description of the database and search functionality

Ask for help and post your question on how to use XnView MP.

Moderators: XnTriq, xnview

User avatar
ErikBachmann
Posts: 4
Joined: Sat Oct 27, 2012 11:32 am

Description of the database and search functionality

Post by 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
Best regards
{ö} Erik Bachmann
User avatar
JohnFredC
XnThusiast
Posts: 2010
Joined: Wed Mar 17, 2004 8:33 pm
Location: Sarasota Florida

Re: Description of the database and search functionality

Post by 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.
John
User avatar
xnview
Author of XnView
Posts: 37571
Joined: Mon Oct 13, 2003 7:31 am
Location: France

Re: Description of the database and search functionality

Post by xnview »

What do you have in Conditions??
Pierre.
User avatar
JohnFredC
XnThusiast
Posts: 2010
Joined: Wed Mar 17, 2004 8:33 pm
Location: Sarasota Florida

Re: Description of the database and search functionality

Post by JohnFredC »

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

Image

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

Disabling "Use database" causes MP to display the proper results of the search.
John
User avatar
oops66
XnThusiast
Posts: 2005
Joined: Tue Jul 17, 2007 1:17 am
Location: France

Re: Description of the database and search functionality

Post by oops66 »

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
XnViewMP Linux X64 - Debian - X64
User avatar
ErikBachmann
Posts: 4
Joined: Sat Oct 27, 2012 11:32 am

Re: Description of the database and search functionality

Post by 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.
You do not have the required permissions to view the files attached to this post.
Best regards
{ö} Erik Bachmann
User avatar
m.Th.
XnThusiast
Posts: 1587
Joined: Wed Aug 16, 2006 6:31 am

Re: Description of the database and search functionality

Post by m.Th. »

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.
m. Th.

- Dark Themed XnViewMP 0.99.6 64bit on Win10 x64 -
User avatar
m.Th.
XnThusiast
Posts: 1587
Joined: Wed Aug 16, 2006 6:31 am

Re: Description of the database and search functionality

Post by 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
m. Th.

- Dark Themed XnViewMP 0.99.6 64bit on Win10 x64 -
User avatar
xnview
Author of XnView
Posts: 37571
Joined: Mon Oct 13, 2003 7:31 am
Location: France

Re: Description of the database and search functionality

Post by xnview »

I see that you have *.*, please try by removing it
Pierre.
User avatar
JohnFredC
XnThusiast
Posts: 2010
Joined: Wed Mar 17, 2004 8:33 pm
Location: Sarasota Florida

Re: Description of the database and search functionality

Post by JohnFredC »

xnview wrote:I see that you have *.*, please try by removing it
Well, that solved the problem, though in a counter-intuitive fashion, IMO.
John
User avatar
m.Th.
XnThusiast
Posts: 1587
Joined: Wed Aug 16, 2006 6:31 am

Re: Description of the database and search functionality

Post by m.Th. »

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. :)
m. Th.

- Dark Themed XnViewMP 0.99.6 64bit on Win10 x64 -
User avatar
xnview
Author of XnView
Posts: 37571
Joined: Mon Oct 13, 2003 7:31 am
Location: France

Re: Description of the database and search functionality

Post by xnview »

Yes, it seems that it's a problem with sqlite :(
Pierre.
User avatar
m.Th.
XnThusiast
Posts: 1587
Joined: Wed Aug 16, 2006 6:31 am

Re: Description of the database and search functionality

Post by m.Th. »

xnview wrote:Yes, it seems that it's a problem with sqlite :(
See your PM :)
m. Th.

- Dark Themed XnViewMP 0.99.6 64bit on Win10 x64 -
User avatar
xnview
Author of XnView
Posts: 37571
Joined: Mon Oct 13, 2003 7:31 am
Location: France

Re: Description of the database and search functionality

Post by xnview »

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