Author Topic: [SQLite] Support to configure pragmas  (Read 3877 times)

0 Members and 1 Guest are viewing this topic.

JoeScylla

  • New member
  • *
  • Posts: 1
    • View Profile
[SQLite] Support to configure pragmas
« 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

IlseKasten

  • Full Member
  • ***
  • Posts: 50
    • View Profile
[SQLite] Support to configure pragmas
« Reply #1 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.