RE: Persisten Connection

2003-04-04 Thread Adam Erickson
> We have a perl cgi program that refreshes every 45 seconds and connects > to a mysql database to update records, overtime. This could have 300 Cache the page for 45 seconds. Subsequent hits see the output from the 1st request and do not require a DB connection. Release the cache after 45 secon

Re: Persisten Connection

2003-04-04 Thread gerald_clark
If the perl program is a daemon, than it can keep the connection open. If you are running the same perl program many times, it will have to make the connection each time. Kory Wheatley wrote: We have a perl cgi program that refreshes every 45 seconds and connects to a mysql database to update r

Persisten Connection

2003-04-04 Thread Kory Wheatley
We have a perl cgi program that refreshes every 45 seconds and connects to a mysql database to update records, overtime. This could have 300 people using this same process, because we are queuing user in the database and when they reach queue position 1 and the resources are low, they are redir