TP9 and Sqlite

[R. Kasten]

I have tried to change SQLite setting to accelerate tasks with assigning PRAGMA-keywords. In Thumbs9.ini this seems to be possible with the entry:

[Startup]
InitialDatabase=Database=Y:\Thumbs.tpdb8s; Driver = {ThumbsPlus SQLite3 ODBC Driver}; Timeout=5000; NoCreat=Yes; SyncPragma=NORMAL

I changed this entry to:

InitialDatabase=Database=Y:\Thumbs.tpdb8s; Driver = {ThumbsPlus SQLite3 ODBC Driver}; Timeout=5000; NoCreat=Yes; SyncPragma=OFF; PRAGMA journal_mode=OFF

I am aware that i lowered the reliability, but with the new setting the work is much faster.
Unfortunately, TP9 overwrites this setting on closing.

It would be nice if this setting is stored permanently.
regards Rainer

[Pete Wieland]

There was a solution for the ini file getting over-written that one of the forum members had posted, but Cerious deleted it, along with all the other fixes and workrounds for TP9.

It seems that they have deleted all the posts that had any mention of the many bugs in their software, and don't even want the user community to fix them.

Perhaps the person who posted the original solution will see this and re-post the workround for you.

[R. Kasten]

Thanks for your notice

[Laura Shook]

Hi Rainer,

Thanks for the report. Phillip is fixing this problem for the next build of ThumbsPlus v9.

Kind regards,
Laura