Darek Dwornikowski wrote: > hi, > My problem is as follows. I am using great DBI for connecting to > postgresql. My script, which connects to the database is run about 3-5 > times per second. Last days we installed pgpool to check if it can speed > up some things. Unfortunatelly there is no difference between the script > connecting to pgpool and the script connectng to normal postgres. The > test were driven for 1000 executions of the script. For on php there a > huge speedup. Did somebody have similar experience ?
It sounds like your issue would be solved by having a persistent database connection, rather than connecting and re-connecting each time. You didn't say whether you were running on the command line or on the web. I would look at at a solution like PPerl ( http://search.cpan.org/dist/PPerl/PPerl.pm ), FastCGI or mod_perl with Apache::DBI. Once you have a persistent perl process, you can hold open the DB handle, and pgpool shouldn't be required. Good luck! Mark
