Messages

31

ThumbsPlus v10 Questions / SQlite3 (Thumbs8.tpdb8s) Performance

« on: 2016-01-08 20:51:30 »

Win7 64-bit.  TP10 build 4007.

For what it is worth and information provided for use at your own risk:

I googled sqlite3odbc.dll which led me to this web site:

  http://www.ch-werner.de/sqliteodbc/

I took a chance and downloaded the sqliteodbc.exe (under Current Version) sqlite odbc driver installation program and installed it.  Ran all the virus checks with no issues.

The sqlite3odbc.dll that comes with TP10 is version 0.81 based on sqlite 3.6.13.

The odbc driver program installs version 0.9992 based on sqlite 3.8.9.

The performance improvement thus far is an order of magnitude.  Still testing but so far so very good.  I am guessing I will have to reinstall this driver with each new version of TP10.

Cheers,
Gary

32

ThumbsPlus v10 Questions / Multiple Databases

« on: 2016-01-03 20:13:12 »

Daan,

When you hit the limit of 2GB and there are no orphans or deleted records, nothing you can do will reclaim space as there is nothing to reclaim.  I have hit the limit and it is not pretty.

Gary

33

ThumbsPlus v10 Questions / TP folders in Program Files and ProgramData

« on: 2016-01-03 18:58:20 »

"OS is Win10 x64. According to Control Panel, I have Thumbsplus 10 4005 and Thumbsplus Digicam 5.5 installed, and nothing else from Cerious. When I have a look at folders under "C:\Program Files (x86)", I see a ThumbsPlus10 folder (23Mb), a "ThumbsPlus 10" folder (153Mb), and a ThumbsPlus9 folder (47Mb)."

This issue was introduced when Cerious decided to name the install folder "ThumbsPlus 10" instead of "ThumbsPlus10".  When the upgrade was done, the existing "ThumbsPlus10" folder was not deleted.  I deleted "ThumbsPlus10" and "ThumbsPlus9" with no consequence.  Be wary of deleting the files in ProgramData as I think they are used by the uninstall process.

If you are running shy of space, try the disk clean up tool in Windows.  It will allow you to safely delete any unnecessary Windows 10 install files.  Also, if you upgraded to Win10 from 7 or 8, you may have a Windows.old folder on the C drive which is literally the system prior to the upgrade.  If you are happy with Win10 installation, you can delete this entire folder.  Google Windows.old for information.

Please proceed with caution.  :)

Cheers,
Gary

34

ThumbsPlus v10 Questions / Multiple Databases

« on: 2016-01-03 18:48:01 »

When you hit the access database limit without any orphans present, compacting does not matter.  You are out of space.

35

ThumbsPlus v10 Questions / TP folders in Program Files and ProgramData

« on: 2016-01-03 18:45:21 »

They may also be used to uninstall the software.

36

ThumbsPlus v10 Questions / Multiple Databases

« on: 2016-01-03 14:06:59 »

I do this myself with TP7 and the Access Database.  To create a new database, open TP, click File|Database|New Database.  To switch between databases, click File|Database|Open Database.

You can also create unique icons to start different databases.  For example create a desktop icon for TP, then right click, select properties and change the target:

"C:\Program Files (x86)\ThumbsPlus7\Thumbs.exe" ""


If you are using TP10, use the SQlite database to lift database size restrictions, otherwise follow the above suggestions if you want to create multiple databases.  However, click Database|New... or Database|Open.

Hopefully this is of some help.

Cheers,
Gary

37

ThumbsPlus Suggestions / Wish list for next version of tplus

« on: 2016-01-02 11:34:30 »

V10 with SQlite database is soooooooooo frustrating.  Sometimes it creates thumbnails very fast.  Most times it just crawls.  For the life of me, I cannot figure out why this happens.  It seems V10 is not consistent in reading configuration settings at startup.

38

ThumbsPlus v10 Questions / Moving multiple folders simultaneously

« on: 2015-11-15 13:18:15 »

> > at the moment I reorganize my picture database using TP 10. That means I move or delete a lot of folders. Is it possible to move or delete multiple folders simultaneously?
>
> I don't know how reliable this is, but: Click on the Filter button (funnel symbol) above your thumbnail listing and choose 'include folders'. This will show a thumbnail in the listing for each subfolder. Now you can select these (multiple) subfolders and drag/drop or move/copy/delete them.
>
> When I tried this in my build 4001 on XP, ThumbsPlus still showed the moved folders in their original folder afterwards (as well as in their new folder, where they actually were), even after a Ctrl-F5 (refresh). It only cleaned them up after I clicked on one of them. However the drag/drop operation itself had been successful.

I tried this on Win7 with Build 4004 and it seemed to work fine.  I display folder thumbnails, so I just selected a couple of folder thumbnails and moved them.  The files moved along with the image thumbnails, but the folder thumbnails had to be refreshed as you indicated.

Good call Daan.

39

ThumbsPlus v7-v9 Questions / Two ThumbsPlus 10 folders after installing 4002

« on: 2015-07-23 13:07:19 »

I never said they are harmful.  The left over ThumbsPlus10 folders/files are not harmful either.  They are, however, indicative of a poorly programmed installer/uninstaller.

40

ThumbsPlus v7-v9 Questions / Two ThumbsPlus 10 folders after installing 4002

« on: 2015-07-23 07:17:02 »

I noticed the same thing.  It appears the installer does not fully take into account the old folder is "ThumbsPlus10" and the new is "ThumbsPlus 10".  Residual files from 4001 remain after the 4002 install.  Also, many "ThumbsPlus10" entries remain in the registry.  I saved the files in "C:\Users\\AppData\Roaming\ThumbsPlus" then uninstalled 4002 and all the residual build 4001 files still remain.  I then deleted all residual "ThumbsPlus10" folders/files and registry entries.

I have not reinstalled 4002.  I figured out a thumbnail size/quality that allowed me to create thumbnails for all files using TP7.

41

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:



These are the DB settings for the second database line:




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

42

ThumbsPlus v7-v9 Questions / View Performance

« on: 2015-07-21 13:01:01 »

I'm getting excellent view window performance with these settings (1920x1200 monitor):



Cheers,
Gary

43

ThumbsPlus v7-v9 Questions / TP10 Build 4001. Disappointment?

« on: 2015-07-19 13:08:31 »

> The execution is much faster than .td4 for me me. TP10 seems to have become even faster when searching. I have no Measurement it's just a feeling.
>
> I prefer the following line:
> Timeout=5000;NoCreat=Yes;SyncPragma=OFF;PRAGMA synchronous = OFF;PRAGMA journal_mode = OFF
>
> Yes you are right this line seems to be stable in the INI, but if you use different DB's on different base this entry will change each time, you use another DB. So I prefer to programatically control this entry.
>
> Just remember, the standard SQLite pragmas are for safe use, speed up will cost safety. But I never had problems.
>
> Regards Ilse

Ilse,

Thanks again for your help.  I am using one SQLite database, so the entry does remain stable.  Safety is not an issue.  My system is on battery backup and I backup the database each time it is modified.

I tried your line and it makes no difference on thumbnail creation.  On my system TP7/.td4 is blinding fast creating thumbnails and search performance is the same if not better with TP7.

The image files and database files are on separate SATA III SSDs.  Not sure what else to do.

Thanks again,
Gary

44

ThumbsPlus v7-v9 Questions / TP10 - Default Layout vs. Like 7 Layout

« on: 2015-07-19 09:29:52 »

OK.  I've seen the light!  I have changed from Like 7 to Default layout (old habits die hard?) and it solves a few complaints:

- blurred initial preview image (now preview pane is always visible)

- unreliable activity indicators and lack of "Tasks (0/0)" counter (now task pane is always visible making the activity indicators and counter unnecessary - unchecked the activity indicators option)

- Ctrl+Tab between panes is much smoother

I lost one column of thumbnail display, but the benefits outweigh that loss.

One feature of TP8/9/10 I absolutely love is the ability to add virtually every menu entry to the toolbar.  The ability to add "Find Similar" to the toolbar is a real plus.

Cheers.

45

ThumbsPlus v7-v9 Questions / TP10 Build 4001. Disappointment?

« on: 2015-07-19 08:02:10 »

> Do you have programming skills? Then the problem would be easily solved with a launcher for TP. It always writes the correct line to the INI before TP starts.
> I have written me such a program and I am very happy with SQLite.
> Maybe Cerious has a better solution soon.
>
> Regards Ilse

Ilse,

Thanks for your response.  This is the database line:

InitialDatabase=Database=D:\IMDBTPA\Thumbs10.tpdb8s;Driver={ThumbsPlus SQLite3 ODBC Driver};Timeout=5000;NoCreat=Yes;JournalMode=Off;SyncPragma=NORMAL

Should I make changes to it?  I may be wrong but the line does not appear to change from one run of TP to the next.  Maybe my expectations are too high?  A few times the performance has approached the .td4 performance, but most of the time considerably slower.

Your suggestions are most appreciated.

Regards,
Gary