> 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 seconds to use the refreshed DB data. > 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 redirected to a web login page. Is there a way to keep one Not sure what you mean here but if this requires a DB hit then caching is less of an option. Although, you would still gain performance by not re-querying the same thing over and over. > persistent connection to the database so that it does have to connection > every time in this perl program, because I believe this is causing a > load on our UNIX box. mod_perl is for you. CGI cannot do persistent connections. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
