PDA

View Full Version : DB connections



corsakh
05-14-2010, 08:52 AM
How many simultaneous client connections does HM perform on a PostgreSQL database when doing complex searches or imports, is it always just one?

fozzy71
05-14-2010, 08:58 AM
No, postgres uses multiple processes/connections, even when not importing.

Task Manager > Processes > Sort by Image Name

I have 6 postgres.exe running right now, and HM is not open.

corsakh
05-14-2010, 09:17 AM
Fozzy, these are not HM processes. I want to know how many connections HM utilizes. Could you ask Roy pls? It seems that its two, but I am not sure.

fozzy71
05-14-2010, 10:18 AM
Fwd'd to Roy.

Rvg72
05-14-2010, 10:36 AM
Hi, each time the database is needed one connection is opened and it carries out the operations for that section of code which could involve a few queries.

There are two main apps that open up connections throughout the session and that is the importer and the actual manager so that is why you might see more than one open connection at a time and also, most queries are done on separate threads so it is possible to have HM run many queries at once with each running on its own connection. For example, if you have long running reports on a huge db and you jump between tabs this could happen.

Roy

corsakh
05-14-2010, 11:44 AM
Thank you.