Topics

1

ThumbsPlus v10 Questions / Built new PC, transferred TP10 and now it runs like a dog [Solved - SQL issue]

« on: 2022-02-01 02:58:23 »

Ok, so just built a new PC with 1 x M.2 drive (C:) where TP10 is installed.
I use a SQL Server database with TP10 via an ODBC connection (System DSN) and that resides on a second 7000MB/s 1TB WD SN850 M.2 drive.  My picture folders are on a 750GB SATA6 disk which is not slow (though I'll likely move them on the SN850 soon).

So I installed TP10 on my new PC and now every single time I go into a folder it says "Building file list" and takes ages to do it. If I switch to another folder and switch back it does exactly the same even though it just built the list a few seconds ago!!
If I try to scroll it then stops after half a page and seemingly has to regenerate all the thumbs.

For years I've used this combo (TP10 and SQL Server DB) on my old PC and there was almost no delay selecting folders - images appeared almost instantly and scrolling was not an issue. Most of my folder have between 50-1500 images in them so they are not massive but every single folder takes ages to build the list so it's like nothing is being cached or saved or whatever.

Even doing CTRL-K to add keywords is taking up to 10 seconds just to appear then 10-20 seconds to assign keywords.

I've checked all the settings in TP10 on my old PC against my new PC and they are  *exactly* the same.

If anything it should be *much* faster than my old PC given my M.2 drives but it's running like an dog with three legs.

I've checked everything I can think of with no luck - can anyone suggest anything?
Is there a log I can view to see if there is some sort of permissions issue or something?

I rely on TP10 big time for my business (supplying property photos to the real estate industry) so I need it to work properly - any help or suggestions would be greatly appreciated. 

2

ThumbsPlus v10 Questions / TPCMD commands only partially work in a script (.bat file)

« on: 2017-06-16 00:59:27 »

I'm not sure if anyone here can/will help because I know that officially TPCMD is not supported but here goes nothing...

Say I have 20 images, Pic001.jpg thru Pic020.jpg freshly added to a folder managed by TP10.  Thumbnails are created and all look good in the program.  I then have a batch file with 20 Keyword commands in it, like so:

tpcmd.exe Keyword("+mountain;+lake;+snow|d:\pics\landscapes\pic001.jpg")
tpcmd.exe Keyword("+desert;+snow;+mountain|d:\pics\landscapes\pic002.jpg")
..etc...
tpcmd.exe Keyword("+river;+waterfall;+jungle|d:\pics\landscapes\pic020.jpg")

The problem is that when I run this script (or any variation on it) to add keywords to a number of images only some of the images in the folder will get keywords assigned, the rest get nothing.  This appears to be random because if I recreate the new images again (or delete all assigned keywords) and run the script again, different images will not get keywords assigned.  Sometimes it's only 2 or 3 and sometimes it's up to half or more of them, but it's never the same twice.

The above example is a very simplified use-case - my real world situation is that the script is auto-generated as part of a C# image management app that I have developed and it doesn't matter if the script is executed from the app or if I run it standalone using cmd.exe, I've never yet seen all the images get assigned their keywords.

Can anyone at Cerious tell me why this would be happening?  Can TP10 only handle a certain amount of TPCMD requests at once? Am I flooding it with too many commands which are not being queued in TP10 correctly?

I have tried catching the output of the commands (when submitting via my C# app) hoping to get an error message or a code or something that gives me a hint of what is going on but the commands do not seem to return anything - am I correct in this?  If not, what is returned and how can I capture it?

I have also noticed other TPCMD commands submitted as part of a script often do not get executed so it seems like there is a definite issue with TP10 'losing' commands submitted via a batch file.

Anyway, just hoping someone can help me out because it stops my photography workflow and causes me a lot of wasted time and effort having to assign custom keywords manually in TP10.

3

ThumbsPlus v7-v9 Questions / Errors converting TP7 SQL Server database to TP8.

« on: 2011-05-28 02:11:02 »

Hi guys,

First, thanks for coming back from the dead and offering support again - I'd given up on TP8 completely as not one of my emails on this subject (or any other) has been answered since Jan 2010 when I first installed it so it's nice to see you back.

Anyway, enough complaining! As the title suggests, I am unable to convert my SQL Server 2005 database from the TP7 schema to the TP8 one as I get many many errors.

I am a professional SQL server and .Net developer so I am very happy to experiment with the script you had to do the conversion.... if only I could get it.  I am really, really keen to switch to TP8 (I paid for it after all!) but I can't until the conversion script works as I have a massive DB of images in my TP7 database and I can't switch to any other format as all my supporting code depends on my TP db being in SQL Server.

I have posted the output of the conversion tool in a seperate post as it was too long to include in this.

TIA for any help or advice you can offer.

Mike