Search found 52 matches

by thenetstriker
18 Nov 19 18:02
Forum: Photo Supreme
Topic: Migrate MS SQLServer to PostgreSQL
Replies: 10
Views: 366

Re: Migrate MS SQLServer to PostgreSQL

As mentioned before, it takes a fraction of a second here to get the results of v_prop. Did you reboot the server? Did you try a vacuum? Did you try a reindex? Yes I've tried all that, but that also didn't help. But did you see the "Edit" part I've added to my last comment? I found out that the vie...
by thenetstriker
18 Nov 19 10:52
Forum: Photo Supreme
Topic: Migrate MS SQLServer to PostgreSQL
Replies: 10
Views: 366

Re: Migrate MS SQLServer to PostgreSQL

I'm using the view for my Android application to get a list of the image properties including the image count. I found the Postgres manual and I changed the memory settings accordingly. The view did get a little bit faster (from 16 to 12 seconds with 866 rows) but it is still not as fast as on the M...
by thenetstriker
16 Nov 19 13:39
Forum: Photo Supreme
Topic: Best practice - mixed macOS and Windows
Replies: 3
Views: 327

Re: Best practice - mixed macOS and Windows

Hi Hert, I'm having the same problem. I also use Photosupreme on Mac and Windows. The only workarround I found is to create a complete copy of the database and change the paths there. This way I have at least a readonly version of the database on my mac. Is there a reason why you don't want to suppo...
by thenetstriker
15 Nov 19 17:32
Forum: Photo Supreme
Topic: Migrate MS SQLServer to PostgreSQL
Replies: 10
Views: 366

Re: Migrate MS SQLServer to PostgreSQL

I have another question about the Postgres Database. I found out that a simple select query to the v_prop view take 16 times longer than on the ms sql server. (16 seconds instead of 1) Is this a known problem or can this be improved with additional indices or settings in the postgres server?
by thenetstriker
15 Nov 19 14:51
Forum: Photo Supreme
Topic: Migrate MS SQLServer to PostgreSQL
Replies: 10
Views: 366

Re: Migrate MS SQLServer to PostgreSQL

Thanks for the quick reply. I'm migrating simply because Postgres is free and runs on a free Linux server. I also have another problem after the migration. All the pictures are not found for some reason. I tried to relocate one of the pictures and that solved the problem but I cannot see any differe...
by thenetstriker
15 Nov 19 12:05
Forum: Photo Supreme
Topic: Migrate MS SQLServer to PostgreSQL
Replies: 10
Views: 366

Re: Migrate MSSQL to Postgres

Thanks Hert, it works for the main database. Can I also migrate the tumbs database with this tool or do I have to recreate all thumbnails? (I got an error that the idUser table was not found when I tried to migrate using the tool)
by thenetstriker
14 Nov 19 23:02
Forum: Photo Supreme
Topic: Migrate MS SQLServer to PostgreSQL
Replies: 10
Views: 366

Migrate MS SQLServer to PostgreSQL

What is the best way to migrate a MSSQL Photosupreme database to Postgres?
by thenetstriker
04 Jun 18 16:40
Forum: Photo Supreme
Topic: lft and rgt colum null
Replies: 6
Views: 1055

Re: lft and rgt colum null

Hert wrote:
31 May 18 21:24
You can install the Single version. Start it and you’ll have the database in your app data folder, Catalog.
Thanks for the hint. I didn't know that the database is generated before the trial exired error message shows. I will update my app soon.
by thenetstriker
31 May 18 14:16
Forum: Photo Supreme
Topic: Can not load DB-Lib client library "dblib.dll"
Replies: 11
Views: 1710

Re: Can not load DB-Lib client library "dblib.dll"

User rights? One thing is sure: something is preventing/blocking PSU from accessing and attaching the required DLLs. I now found out what is causing this problem. I've monitored what the application tries to load on startup with the Process Monitor from Sysinternals. I found out that the dblib.dll ...
by thenetstriker
31 May 18 12:04
Forum: Photo Supreme
Topic: lft and rgt colum null
Replies: 6
Views: 1055

Re: lft and rgt colum null

You can get that by opening the Photo Supreme database in a SQLite tool(e.g. SQL Expert) CREATE VIEW v_prop AS SELECT p.*, ( SELECT Count(1) FROM ( SELECT DISTINCT d.catalogitemguid FROM idcatalogitemdefinition d, ( WITH recursive lowerparent(guid, parentguid) AS ( SELECT px.guid, px.parentguid FRO...
by thenetstriker
29 May 18 20:45
Forum: Photo Supreme
Topic: lft and rgt colum null
Replies: 6
Views: 1055

Re: lft and rgt colum null

These columns are not used anymore (for years already). Thanks for the info. I'am currently using those columns in my Android app to calculate the photo count for each property. For this I export my SQL Database to SQLITE and load the database on the Android app. But sadly the v_prop view cannot be...
by thenetstriker
29 May 18 11:52
Forum: Photo Supreme
Topic: lft and rgt colum null
Replies: 6
Views: 1055

lft and rgt colum null

For some reason I have several rows in the idProp table where the lft and rgt column are null. Is there a way to rebuild these values?
by thenetstriker
28 May 18 9:02
Forum: Photo Supreme
Topic: Can not load DB-Lib client library "dblib.dll"
Replies: 11
Views: 1710

Re: Can not load DB-Lib client library "dblib.dll"

Hert wrote:
25 May 18 19:13
For the dblib.dll to load you also need the libiconv.dll
Both are installed with PSU in the installation folder.
The libiconv.dll file is also in the folder. Any other ideas?
by thenetstriker
25 May 18 9:29
Forum: Photo Supreme
Topic: Can not load DB-Lib client library "dblib.dll"
Replies: 11
Views: 1710

Re: Can not load DB-Lib client library "dblib.dll"

Maybe a virus scanner? I already tried to disable the virus scanner and then run the application, but the error still occurs. I also compared the file size and the content of the dll from the computer where the program is working with the one where it isn't and there are no differences. Are there m...
by thenetstriker
24 May 18 19:54
Forum: Photo Supreme
Topic: Can not load DB-Lib client library "dblib.dll"
Replies: 11
Views: 1710

Re: Can not load DB-Lib client library "dblib.dll"

Is dblib.dll in the installation folder? That is the folder that also holds idimagersu.exe If so, have you tried to redownload and install again? If so, what is your SQLServer version? I've just completely redownloaded and reinstalled the application, but the error still shows. As I wrote in the fi...