theguru97321
IS-IT--Management
Is there a way I can open / connect to my database 1 time through out a session? an not have to open and close it for every single click?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
CGI / DBI / redundant
- Thread starter theguru97321
- Start date
- Status
Sure! Just put all of your SQL statements together before you close the connection.
But why would you want to do this? The connection is almost instantaneous and precludes any problems you might have with other users trying to access the same database. (You should be locking the database for each user/session whenever you're adding, editing, or removing data. A lock isn't always necessary for a read-only query.)
There's always a better way. The fun is trying to find it!
But why would you want to do this? The connection is almost instantaneous and precludes any problems you might have with other users trying to access the same database. (You should be locking the database for each user/session whenever you're adding, editing, or removing data. A lock isn't always necessary for a read-only query.)
There's always a better way. The fun is trying to find it!
- Status