Thumbnail db

[obelisk]

Today I looked at my Thumbnail db file since my xnview takes 15s to load now. It had 1356 fragments. Is anything being done to address this?

[punter]

Today I looked at my Thumbnail db file since my xnview takes 15s to load now. It had 1356 fragments. Is anything being done to address this?

That is ordinary for pants filesystem.

[xnview]

Today I looked at my Thumbnail db file since my xnview takes 15s to load now. It had 1356 fragments. Is anything being done to address this?

15s, it's really strange? Try to rename the category.db?

[obelisk]

That is ordinary for pants filesystem.

Yes but yet all other programs get around this by preallocating or other means.

15s, it's really strange? Try to rename the category.db?

It takes about 10-15s to enter any pre-cached folder of 100+ pics, even if those pics have no category set. For folders with no cached pics it's immediate.

[Clo]

Pierre

Hello !

“obelisk” wrote

Yes but yet all other programs get around this by preallocating or other means.

• For instance, in Total Commander we have the following INI entry :

ThumbnailPrealloc=100000
¤ Sets number of bytes to pre-allocate when creating the thumbnails database to avoid fragmentation.
…

KR
Claude
Clo

[xnview]

15s, it's really strange? Try to rename the category.db?

It takes about 10-15s to enter any pre-cached folder of 100+ pics, even if those pics have no category set. For folders with no cached pics it's immediate.

15s?? Do you have tried optimise on DB?

[obelisk]

No not yet, what does optimise do? I thought it just removes deletes files, which I don't have any of.

[pic_viewer]

Download the freeware Defraggler from Piriform. It allows you to defragment only xnview.db file in blazing speed. Quicker than complaining here and waiting for an improvement...

[JohnFredC]

2pic_viewer

Wow! That Defraggler thing is very useful! Thanks for pointing it out!

[obelisk]

defrag does nothing to the speed. I do it every 2wks anyway due to this stuff.

[JohnFredC]

Every tiny little bit adds up, over time, even if you can't detect improvement of a single instance

[xnview]

No not yet, what does optimise do? I thought it just removes deletes files, which I don't have any of.

Yes, and make a "VACUUM" command on the DB.
How many files do you have in the DB?

[ckv]

[offtopic]

Download the freeware Defraggler from Piriform. It allows you to defragment only xnview.db file in blazing speed. Quicker than complaining here and waiting for an improvement...

Wow! That Defraggler thing is very useful! Thanks for pointing it out!

I must say, Piriform tools Recuva and CCleaner are great, but Defraggler once screwed up my system to unbootable state and i'm not the only one who got problems like this with Defraggler. So just a warning.

As an alternative here for Defraggler, I would recommend Sysinternals (Microsoft) Contig command line file defragmenter.

[pic_viewer]

Of course there were versions of Defraggler that made problems. Same for every software, including XnView. Check the history listing. The current version is more than stable and includes lots of features that a command line version will never have.

[obelisk]

Of course there were versions of Defraggler that made problems.

Way to increase confidence. I've used 5 defrag programs since the days of Win95 and none of them ever created problems. When doing data critical software NO you should not have problems. They should be tested differently to eg xnview which won't delete your partition by mistake...


Tried the optimize on db, it still takes almost 10s to switch to a dir of raw files. Dir of jpg takes a little less. I have about 12k files in db.