> Re: Upgrading installation of SQLite.
>
> Tell us where files exist, and where to make the entries. Provide notes of everything that must be changed IN ONE PLACE! Make it complete. I don't want to work that hard, or take the risk of getting something wrong.
>
> Write a how to, and ask that it be put on Cerious' website where it can easily be found.
>
> Thanks.
IF ANY OF THE FOLLOWING MAKES YOU UNCOMFORTABLE, DO NOT DO THIS!!
For Windows 7 and 10 these are the steps I took to improve the performance of the SQLite database with TP10 (I would guess this will work with TP9 and TP8):
Before you start, be sure that TP10 is not running!
1) Go to the following web site and download the sqliteodbc drivers:
http://www.ch-werner.de/sqliteodbc/Scroll down the page if necessary for this grouping of text:
Current version
sqliteodbc.exe <--click to download (even for 64bit Windows!)
sqliteodbc_w64.exe <--NO!
sqliteodbc-0.9995.tar.gz <--NO!
sqliteodbc-0.9995-1.src.rpm <--NO!
2) Go to folder where "sqliteodbc.exe" was saved and double click to install (virus scan first if you have doubts, but I have never had a single problem with this exe file).
The odbc driver will be installed in the folder:
"C:\Program Files (x86)\SQLite ODBC Driver"
NOTE! Save the "sqliteodbc.exe" as you will need to repeat steps 2 thru 6 if you install/reinstall TP10.
3) I am not sure if this step is necessary, but I do it regardless:
As the administrator using a file manager:
- go to the folder "C:\Program Files (x86)\SQLite ODBC Driver"
- copy (DO NOT MOVE!) the file "sqlite3odbc.dll" to the folder
"C:\Program Files (x86)\ThumbsPlus 10\Odbc"
- This will overwrite the existing "sqlite3odbc.dll" file.
4) Use a text editor to modify the file:
"C:\Users\
\AppData\Roaming\ThumbsPlus\Thumbs10.ini"
Edit this line to include the name=value parameters shown:
InitialDatabase=Database=\Thumbs8.tpdb8s;
Driver={ThumbsPlus SQLite3 ODBC Driver};Timeout=5000;NoCreat=Yes;JournalMode=Off;SyncPragma=NORMAL
Save the file.
5) This is likely not necessary, but I reboot the computer at this point.
6) Start TP10 and you should see a dramatic improvement in performance.
I hope you find this write up useful.
Again, if any of this gives you concern, DO NOT DO ANY OF IT.
Cheers.