Hello,
This message is urgent and could save our banner exchange.
Recently we started growing so fast that we had to convert our entire system
at Traffic-Exchange.com to mysql. Now that this is done we need persistant
database connections to the mysql server. From downloading the Apache::DBI
module I have no idea how to set this up.
But what I can tell you is that we connect to the mysql database 1 time for
every banner that is called by having this in our perl script:
use DBI;
$dbh =
DBI->connect("dbi:mysql:$mysqldatabase","$mysqlusername","$mysqlpassword") ||
die("Couldn't connect to database!\n");
&updatedatabase;
$dbh->disconnect;
Each time a banner is called that code is execuited meaning the database
would open over 1,000 in a few min.
>From seeng this how is it that I can change this to use your module for
persistant connections and what is it I need to do.
The README was a bit confusing.