Possible to do Connect Caching? connect, pull, wait 30secs, pull
am 18.09.2007 08:02:13 von Ow.Mun.HengCurrent script does this in sequence.
connect
pull data based on select
copy/import into PG
wait 30 secs
connect again.
I've turned on connection logging in PG and I noticed that I keep
seeing
LOG : connection received
statuses.
Which means that the script is connecting to the server every 30s.
What I don't know is..
1. is the script using the same connection or is re-connecting afresh
each time. (how can I tell?)
2. would connect_cache help in this to reduce the # of connect and
re-connect to the server?
Any help/comments appreciate.