in reply to DB Connection pool
Are you sure this will help? Unless your database server has multiple processors it is unlikely that running multiple queries in parallel will be substantially faster than running the same queries serially.
If you do have multiple processors on your database server, then my suggestion would be to fork() N processes to each do 1/N of the work (N = number of available processors). Each process can then establish a private database connection, saving you the trouble of dealing with connection pools.
Of course, more complicated schemes are possible but they are unlikely to be worth the effort.
-sam
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Re: DB Connection pool
by dsheroh (Monsignor) on May 07, 2002 at 14:37 UTC | |
by samtregar (Abbot) on May 07, 2002 at 18:12 UTC |
In Section
Seekers of Perl Wisdom