Re: DB speed
| From: | Dan Ostrowski | Date: | Thu, 10 Oct 2002 22:20:14 +0000 |
| Subject: | Re: DB speed | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-119585@lists.php.net to get a copy of this message | ||
Yes persistant connections to pg make a LOT of difference and are recommended.. I have never had overhead problems using them eaither. I am terribly sorry i didn't mention this before.
Just make sure you have proper indexes and you should be good to go.
regards,
dan
Uros Gruber wrote:
Hi! I make some more test for this. When i enable pconect (persistant) the result amazed me. PGSQL Total time: 0.0070 Execution time: 0.0034 MySQL Total time: 0.0072 Execution time: 0.0027 Now PGSQL is as fast as mysql or maybe a littttttttle slower. So is this normal that non-persistant is so much overhead for pg. Is there any tools to check this. Or is some kind of a bug in php. I use 4.2.3. And pg is 7.2.1. Can somebody make some test. I can send script what i've run.