0.83: Operations on categories slow

[jadO]

I don't know if it is a real bug. But using the sidecar filter categories, it seems to be extremely slow.

[xnview]

I don't know if it is a real bug. But using the sidecar filter categories, it seems to be extremely slow.

what do you mean by sidecar filter categories??

[jadO]

I don't know if it is a real bug. But using the sidecar filter categories, it seems to be extremely slow.

what do you mean by sidecar filter categories??

I mean the category filter pane. Anything related to it is slow: Selecting multiple, deselection, creating thumbnails with having categories selected.

[xnview]

even selecting a rating?

[m.Th.]

I don't know if it is a real bug. But using the sidecar filter categories, it seems to be extremely slow.

what do you mean by sidecar filter categories??

I mean the category filter pane. Anything related to it is slow: Selecting multiple, deselection, creating thumbnails with having categories selected.

1. How many categories do you have selected? 5? 10? 100?
2. How many categories do you have in total? 100? 500? 1000?
3. In Tools | Settings | Catalog | Memory usage for database engine: - what value do you have?
4. What storage do you have? HDD? SSD?
5. How much memory do you have?

[m.Th.]

even selecting a rating?

...perhaps separate indices on ImageID and (especially) TagID would help in table TagsTree... - but this needs real benchmarking on his system...

[jadO]

even selecting a rating?

Yes everything to select in that pane slows down XnViewMP.

1. How many categories do you have selected? 5? 10? 100?
2. How many categories do you have in total? 100? 500? 1000?
3. In Tools | Settings | Catalog | Memory usage for database engine: - what value do you have?
4. What storage do you have? HDD? SSD?
5. How much memory do you have?

1. Depends: 1- 20
2. There is no easy way to count. Maybe 300-500
3. 500 MB
4. HDD
6. 12 GB

[m.Th.]

even selecting a rating?

Yes everything to select in that pane slows down XnViewMP.

1. How many categories do you have selected? 5? 10? 100?
2. How many categories do you have in total? 100? 500? 1000?
3. In Tools | Settings | Catalog | Memory usage for database engine: - what value do you have?
4. What storage do you have? HDD? SSD?
5. How much memory do you have?

1. Depends: 1- 20
2. There is no easy way to count. Maybe 300-500
3. 500 MB
4. HDD
6. 12 GB

Hmmm... it shouldn't make any difference. I don't know what SQL Pierre uses - he should use a (NOT) IN predicate and put the values of TagID as numbers in there - this is the fastest way.

Besides that, a common problem (dunno if it is fixed now) on XnView and other programs are the so-called 'offline files' or 'hard-to-reach files'.

Let's say that I have cataloged some files which I don't have access anymore (the volume went offline - think a unplugged external USB disk) or a slow media - for example a slow (WiFi?) LAN share, a clogged disk etc.

When I do my filter, the program grabs ALL the files which met the condition, regardless of directory (do you use the filter with the scope ALL or 'This Directory Only'?) hence it can try to show offline files or hard-to-reach files which would slow all the system.

Questions
1. (again): Do you use the filter with the scope "ALL" or "This Directory Only"'? (it is located in the 'Match' drop-down at the top of the pane)
2. If you do such a filter how many photos do you get? 10? 100? 1000?
3. Which file format?
4. How big are the files on average?

[xnview]

even selecting a rating?

Yes everything to select in that pane slows down XnViewMP.

Is it possible to have the database file?

[jadO]

Is it possible to have the database file?

No.

[xnview]

Is it possible to have the database file?

No.

not easy to understand what's happened

[m.Th.]

Is it possible to have the database file?

No.

You didn't respond to my last message (4 questions there)...