General :: Speeding Up Script By Opening And Closing DB Connection Just Once?

I have a script which takes a file as input and reads it in while loop cuts the name of table and stores in a variable opens DB connection and queries for rowcount in that table closes the connection reads another file and then follows step 1 through 4 till EOF is reached. Now this script is taking longer to execute maybe because the DB connection is opened and closed each time.

My scripts is:

Code:

#!/bin/ksh
cat logcountOP | while read LINE
TBLName=`echo $LINE|cut -d "-" -f1`

[code].....

I was thinking of changing this.I want to open the DB connection just once and then query it for all tables and then exit.