persistant database connection

[goodtalka]

I am creating a web application (using CGI perl) where in I have lot of links on a page which, each link will run the same cgi script to retrive different data from the database.It takes lot of time each time to connect to the database and retrive, so I want a way where in I can connect to the database only once and that connection exists throughout so that retrival will be faster.How can I do it? Please Help!

 

[133tcamel]

use mod_perl and then load Apache:BI..
it'll give you a peristant connection and also do the dirty work of pinging the database connection before assiging it accross script(s) ---
cheers!
san.

 

[goodtalka]

Where can I get the mod_perl-2 binaries ? I checked out some of the binaries but that didn't work (from the site

http://theoryx5.uwinnipeg.ca/ppmpackages/mod_perl-2.ppd),

this binary is not meant for MSWin32-x86-multi-thread. Please help!

 

[133tcamel]

look on

http://perl.apache.org/

---
cheers!
san.