Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Gary

Pages: 1 [2] 3 4 ... 15
16
> Revision.
>
> In further testing, it appears the following step is NOT necessary.  Likely the original sqlite3odbc.dll file in this folder is used during the TP10 installation process and not when the program itself is run:
>
> 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.
>

>
> The "sqliteodbc.exe" install will place the "sqlite3odbc.dll" odbc driver in the folder "C:\Windows\SysWOW64" for 64-bit Windows 7 and Windows 10.
>
> I do not have access to a 32-bit Windows system, so I don't know where the dll file would end up in that case.

Ugh.  Step 3) IS necessary! especially in Windows 10

17
Revision.

In further testing, it appears the following step is NOT necessary.  Likely the original sqlite3odbc.dll file in this folder is used during the TP10 installation process and not when the program itself is run:

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.


The "sqliteodbc.exe" install will place the "sqlite3odbc.dll" odbc driver in the folder "C:\Windows\SysWOW64" for 64-bit Windows 7 and Windows 10.

I do not have access to a 32-bit Windows system, so I don't know where the dll file would end up in that case.

18
> 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.

19
ThumbsPlus v10 Questions / Database Error
« on: 2016-11-04 10:00:54 »
You have hit the dreaded 2GB limit of the Access Database. You can cut back on thumbnail size/quality, eliminate keywords, etc to try to cut down on the record size for each thumbnail to fit more in the 2GB limit.  You could divide your images into multiple databases.  Otherwise, you are stuck.  :(

20
ThumbsPlus v10 Questions / Video controls in viewer
« on: 2016-09-25 17:54:10 »
Hey Gary,

This a a bug in TP10 I've complained about and nothing has been done to fix it.  I hold out no hope it will ever be fixed.

I find in this situation the program can hang to the point I have to kill it with task manager.  Try to avoid the situation.

Maybe Daan has a work around for this.

Cheers,
Gary

21
I see no change in the way TP handles PDF files.  Double-click opens the image only.  Shift-double-click opens the PDF file in default PDF program.  Shift-enter also opens the PDF file in the default PDF program.  See if that works for you.

Cheers,
Gary

22
They have messed up the copy timing again.  I would recommend you go back to 4005 - it is not as sensitive.  4009 became impossible to use as I copy/move files often.

Seriously Cerious ... are you able to fix issues without introducing new ones?

23
Drag and Drop from thumbs pane to location pane (i.e. moving/copying files from one folder to another) has become frustratingly unreliable.  It may take several attempts to get the file to move/copy.  This makes 4009 unusable.  Back to 4005.

Cerious:  GET IT TOGETHER

24
ThumbsPlus v10 Questions / 4005 vs 4007
« on: 2016-03-16 19:21:04 »
What is the deal?  The web site now says 4005 is an official release (but still beta) because 4007 has a couple of significant issues.  Anyone know the issues?  Should 4007 even be available to the user community?  I reinstalled 4005 and of course had to reinstall the SQlite3 ODBC driver.

25
ThumbsPlus v7-v9 Questions / Upgrade from 7 to 10?
« on: 2016-03-02 19:53:00 »
Regardless of the TP version ... if you choose the access database (Thumbs.tpdb8) you will have to endure the 2GB limit.  If you choose the SQlite database (Thumbs.tpdb8s) you will not have the 2GB limit.  Hope this helps.

26
ThumbsPlus v10 Questions / Ghostscript
« on: 2016-02-27 09:13:25 »
FYI, 9.18 is the latest release.  Might be worth a try to see if it fixes your problem.  Here is a link to the history of changes to ghostscript:

http://www.ghostscript.com/doc/9.18/History9.htm

27
ThumbsPlus v10 Questions / Slide Sorter Capability
« on: 2016-02-11 16:44:58 »
To accomplish this, I use the free Bulk Rename Utility:

http://www.bulkrenameutility.co.uk/Main_Intro.php

This program can be a bit daunting at first, but it has the most flexibility of any rename program I've encountered.  I have it linked as an external program in TP10 and TP7 with the folder name passed so I can rename from within TP.

Cheers,
Gary

28
ThumbsPlus v10 Questions / Error in thumbs10.ini
« on: 2016-01-15 21:05:15 »
I have no idea what they mean, but here are the settings from my Thumbs10.ini file:

Flags=201326600
SmallModeFlags=201326600
LargeModeFlags=201326601
CustomModeFlags=629146143
ListModeFlags=92275209
ReportModeFlags=226495039


I am using one tpdb8s database.

Have you tried to repair the database?  Recreate it?

Cheers.
Gary

29
This ability is available in TP10.  Open TP10, then click menu Database | New ... to get dialogue box to create a new database.  Select option "Store thumbnails in files", then create your database.

This is just my opinion, but I think this is not a good way to go especially if you have a lot of image files.  It can lead to bad directory fragmentation (not so much of a problem on an SSD) and unless Cerious has addressed this issue, maintenance problems. When an image is deleted from within TP10, the thumbnail image file remains.  Removing orphans removes the rows from the database, but not the corresponding thumbnail image files.

I see absolutely no reason to do this with the availability of the SQlite database which lifts the dreaded 2GB database size limit.

Cheers,
Gary

30
Yup.  The performance improvement makes TP10 an entirely different program.

Pages: 1 [2] 3 4 ... 15