Simulation output using libpq
Dear All,
I have some c code that writes results directly to a file as they're
produced during a simulation. I want to modify the code to write
directly to a postgres database using libpq. I think I could open a
connection and insert into the database with a transaction, commiting at
the end of the simulation. One problem with this approach is that if I
have a lot of simultaneous simulations running I may run into problems
with exceeding the maximum number of connections allowed. I would
welcome any advice
Many thanks
Colin
_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today!
http://www.msn.co.uk/messenger
Sorry, what's to keep you from increasing the max number of connections?
On Thu, 8 Jan 2004, C G wrote:
Show quoted text
Dear All,
I have some c code that writes results directly to a file as they're
produced during a simulation. I want to modify the code to write
directly to a postgres database using libpq. I think I could open a
connection and insert into the database with a transaction, commiting at
the end of the simulation. One problem with this approach is that if I
have a lot of simultaneous simulations running I may run into problems
with exceeding the maximum number of connections allowed. I would
welcome any adviceMany thanks
Colin
_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today!
http://www.msn.co.uk/messenger---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly