m.Th. wrote:...There are several things here...
First, thanks for your expertise !
"1st, Pierre should give us, the ones who use mechanical HDDs (but not only) the possibility to change the location of db on another drive (not only partition - drive). But of course, we need another HDD. I have, but I understand the ones who doesn't."
... Right, to have the ability to improve the performance of the new "XnView.xndb" file.
"2nd, (aside of bugs in ppt processing and such) perhaps is better to have a way to speed up the db loading by eliminating some possible unnecessary queries (see my previous post)"
...Very interesting, some tests must be done first probably...
"3rd, tweak the thumbnail generation - for example commit on SQLite db after 100, 500 or even 1000 thumbnails. Anyway is a data generation which if the system crashes
exactly when this is happening, it can be manually regenerated without too much hassle.
I think that we could achieve important performance gains here without too much hassle. But perhaps this is already implemented?"
... I support this kind of "db custom tweak".
"4rd, perhaps move the blocking part of generation of thumbs in a separate thread? ...but this, even if will solve the problem of 'freezing' could be a complicated change, depending of the program's internal architecture. Also, here one can gain speed by having a high-priority thread etc."
... I think than some tests must be done too ?
If the DB is redesigned, maybe it's the time to also add some interesting news fields like for example:
- EXIF date taken (for a new functionality, tree by date - as option)
Code: Select all
2012(years)
-- 01(month)
-- 30(days)
-- 23(hours)
- and some others fields, ... etc ... ?
