Page 1 of 1

alpha forum topic "Database size"

Posted: Thu Aug 17, 2006 6:02 pm
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

Re: alpha forum topic "Database size"

Posted: Fri Aug 18, 2006 7:06 am
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???