alpha forum topic "Database size"

Bugs and Suggestions in XnView Classic which have been resolved

Moderators: XnTriq, xnview

klaus2

alpha forum topic "Database size"

Post by klaus2 »

<Moderator's note: This topic has been moved>

Pierre,

about grow of the db, would it be an option to apply the autovacuum pragma
sqlitedb.execsql('pragma auto_vacuum = 1');
instead of relying on the user's housekeeping? (if not: why: speed?)

btw: i found my thumbsdb to be now in the window's application data dir;
i would prefer to keep it relative (important: relative!) to my xnview's
program directory, just as before. Did i miss something?

Kind Regards,
klaus2
User avatar
xnview
Author of XnView
Posts: 36821
Joined: Mon Oct 13, 2003 7:31 am
Location: France

Re: alpha forum topic "Database size"

Post by xnview »

klaus2 wrote:<Moderator's note: This topic has been moved>

Pierre,

about grow of the db, would it be an option to apply the autovacuum pragma
sqlitedb.execsql('pragma auto_vacuum = 1');
instead of relying on the user's housekeeping? (if not: why: speed?)
Yes, speed, and you can use optimize
btw: i found my thumbsdb to be now in the window's application data dir;
i would prefer to keep it relative (important: relative!) to my xnview's
program directory, just as before. Did i miss something?
Now all data are stored in user directory, you can change it in option/Cache
But why do you want it relative???
Pierre.