alpha forum topic "Database size"

[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

[xnview]

<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???