46
ThumbsPlus v7-v9 Questions / TP10 Build 4001. Disappointment?
« on: 2015-07-21 16:35:51 »
Ilse,
Thanks again for your input. My question is why is SQLite so much slower creating thumbnails vs TP7/TD4 when using the exact same thumbnail settings in both?
I modified the database entry per your recommendation and noted the performance:
InitialDatabase=Database=D:\IMDBTPD\Thumbs8.tpdb8s;Driver={ThumbsPlus SQLite3 ODBC Driver};Timeout=5000;NoCreat=Yes;JournalMode=Off;PRAGMA synchronous = OFF;PRAGMA journal_mode = OFF
I modified the database entry to:
InitialDatabase=Database=D:\IMDBTPD\Thumbs8.tpdb8s;Driver={ThumbsPlus SQLite3 ODBC Driver};Timeout=5000;NoCreat=Yes
There is absolutely no difference in performance between the two.
I installed the SQLIte Manager plugin for Firefox and it appears TP forces options on/off regardless of what the database line specifies.
These are the DB settings for the the first database line:
![](http://images/uploaded/2015072120304155aeabf121668.jpg)
These are the DB settings for the second database line:
![](http://images/uploaded/2015072120311855aeac16b9b46.jpg)
I'm confused about what purpose the InitialDatabase entry serves other than to define the database name and ODBC Driver.
Laura, could you provide further help?
Kindest regards,
Gary
Thanks again for your input. My question is why is SQLite so much slower creating thumbnails vs TP7/TD4 when using the exact same thumbnail settings in both?
I modified the database entry per your recommendation and noted the performance:
InitialDatabase=Database=D:\IMDBTPD\Thumbs8.tpdb8s;Driver={ThumbsPlus SQLite3 ODBC Driver};Timeout=5000;NoCreat=Yes;JournalMode=Off;PRAGMA synchronous = OFF;PRAGMA journal_mode = OFF
I modified the database entry to:
InitialDatabase=Database=D:\IMDBTPD\Thumbs8.tpdb8s;Driver={ThumbsPlus SQLite3 ODBC Driver};Timeout=5000;NoCreat=Yes
There is absolutely no difference in performance between the two.
I installed the SQLIte Manager plugin for Firefox and it appears TP forces options on/off regardless of what the database line specifies.
These are the DB settings for the the first database line:
![](http://images/uploaded/2015072120304155aeabf121668.jpg)
These are the DB settings for the second database line:
![](http://images/uploaded/2015072120311855aeac16b9b46.jpg)
I'm confused about what purpose the InitialDatabase entry serves other than to define the database name and ODBC Driver.
Laura, could you provide further help?
Kindest regards,
Gary