in reply to MSSQL and Perl - heavy load

I assume that the connect and disconnect to/from the DB have been copied in only for clarity. If you do this in every function, your heavy DB load is expected.

Replies are listed 'Best First'.
Re^2: MSSQL and Perl - heavy load
by taomanjay (Novice) on Jan 11, 2010 at 18:02 UTC
    Oh, that is exactly how the function works. I know it is not ideal, but it is also not the cause of the heavy load. This function basically gets called a total of 60 times. This is a temporary script and the next iteration of the script will be nicer with the DB connections. I know why we have the load, it's due to other things which I am aware of and have no control over.
[reply]

In Section Seekers of Perl Wisdom