In principle, I am really satisfied with the scope and performance, but the slowness of the program is making me think about switching.
Until now, I thought it was mainly due to my hardware. I therefore bought a powerful desktop PC (i7-14700K, 32GB, nvidia GFX) but unfortunately this hasn't changed anything.
I use the server version. When I import 100 images, it takes ages (1h). My computer is bored to death (5% utilization), network activity in the same range. Even when all the work is done and I want to filter for files, changing a filter means that I have to wait seconds for the program to respond again. How can I analyze the reason for this?
I use the latest v2024 with Postgres15 on my server connected via Ethernet (1gbit). I assume that the SQL version is not faster, right?
How to debug Slowness?
Re: How to debug Slowness?
With my user-to-user hat on...
I just did an import of 100 images in the PostgreSQL version (images stored on a network share, connected via Wifi, database stored on the local machine. The import finished (from start to finished synchronizing) in 83 seconds. If the images were stored locally it would be faster. My computer holds a i7-10710U, 32GB RAM and a 3500MB/s NVMe SSD which is not the fastest these days)
If the computer running PSU is bored then the time is apparently spent somewhere else.
Where are your images stored?
Where is the PostgreSQL database stored?
What type of drive is the PostgreSQL database and the Image files stored on?
Did you configure PostgreSQL as outlined in the installation instruction? Also configured the Virus scanner?
I just did an import of 100 images in the PostgreSQL version (images stored on a network share, connected via Wifi, database stored on the local machine. The import finished (from start to finished synchronizing) in 83 seconds. If the images were stored locally it would be faster. My computer holds a i7-10710U, 32GB RAM and a 3500MB/s NVMe SSD which is not the fastest these days)
If the computer running PSU is bored then the time is apparently spent somewhere else.
Where are your images stored?
Where is the PostgreSQL database stored?
What type of drive is the PostgreSQL database and the Image files stored on?
Did you configure PostgreSQL as outlined in the installation instruction? Also configured the Virus scanner?
This is a user-to-user forum. If you have suggestions, requests or need support then please send a message
Re: How to debug Slowness?
Your desktop is likely not the issue.
I'd look at the server, and the network from server to your PC. There may be some authentication that is creating overhead.
Like Hert, I import images quickly, even though my server is an old underpowered AMD server from 2010.
I use PostGreSQL and find it to be plenty fast.
I'd look at the server, and the network from server to your PC. There may be some authentication that is creating overhead.
Like Hert, I import images quickly, even though my server is an old underpowered AMD server from 2010.
I use PostGreSQL and find it to be plenty fast.
Gordon Currie
Photo Supreme 2024 PostgreSQL on Windows Server Essentials 2016
Photo Supreme 2024 PostgreSQL on Windows Server Essentials 2016
Re: How to debug Slowness?
1h is even too much for 1K or perhaps even 10K images.
I had to do a little bit of googling to find the Postgres settings that make a difference and then some tuning and testing.
My setup looks very much the same as yours, although without the Ethernet connection. So, i'd test and tune that first.
I had to do a little bit of googling to find the Postgres settings that make a difference and then some tuning and testing.
My setup looks very much the same as yours, although without the Ethernet connection. So, i'd test and tune that first.
Re: How to debug Slowness?
But you don't write anything about how your server is equipped.
Re: How to debug Slowness?
Many thanks to all of you. The problem was indeed the resources on the server.