Hi,
I have a perl script that talks to a Sybase database through DBI to
DBD::Sybase.
The insert or update queries seems to open up an new TCP connection for each
update or insert that the script has to perform.
Once the statement has been executed it leaves the port in TIME_WAIT and
will then open up a new connection to execute the next non-select query.
I have tried both the $Sth->do() and the prepare/execute method and they
both do the same.
I only connect to the database once with the DBI->connect() and don't close
the connection until the script has finished.
I am concerned that under heavy load, the resources of the Database or TCP
stack will be used up.
Is this a valid concern ?
Is there any way around this if this is the case ?
Select statements do not seem to have this problem.
Both the DBI and the DBD::Sybase are the latest versions (V1.21 and 0.94
respectively).
Thanks for any help.
Michael Eales
