ThumbsPlus

All forums => ThumbsPlus Suggestions => Topic started by: JoeScylla on 2012-07-30 05:45:13

Title: [SQLite] Support to configure pragmas
Post by: JoeScylla on 2012-07-30 05:45:13
It would be nice to configure the pragmas of a SQLite database; especially the "synchronous" pragma. "synchronous" is set on FULL per default which is very very safe but also very very slow. It would be nice to set to be able to set "synchronous" to NORMAL or even OFF to speed up thumbnail creation (OFF is ~50 times faster then FULL).

See also:
- http://www.sqlite.org/pragma.html
- http://www.sqlite.org/pragma.html#pragma_synchronous
Title: [SQLite] Support to configure pragmas
Post by: IlseKasten on 2012-08-05 11:21:14
I agree with this point. E.G.: Deleting of a gallery which contains thousands of pictures takes up a lot of time. In such cases a switch should exist to accelerate such duties.