Re[2]: [PEAR] DB class speed
| From: | Uros Gruber | Date: | Thu, 10 Oct 2002 20:32:26 +0000 |
| Subject: | Re[2]: [PEAR] DB class speed | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-2474@lists.php.net to get a copy of this message | ||
Hi!
I don't think so. Config is OK, because i made some test with
persistant connections and here is the results for this
PGSQL
Total time: 0.0070
Execution time: 0.0034
MySQL
Total time: 0.0072
Execution time: 0.0027
As you can see time is almost the same. Is it possible that
there is some kind of a bug or what.
I also try with pure php functions and results where also bad
with non-persistant and very good with persistant. Can be
phps fault to slow things down. I use php 4.2.3.
--
tia,
Uros mailto:uros.gruber@sir-mag.com
Thursday, October 10, 2002, 3:13:39 PM, you wrote:
MT> Hi Uros,
MT> I've also run some tests to see the speed difference and it was below
MT> 2%. It probably means that you've misconfigured something.
MT> On Thu October 10 2002 3:14 pm, Uros Gruber wrote:
>> Hi!
>>
>> I'm making some testing over DB.php
>>
>> And i wan't to know if this is normal.
>>
>> I've made some script where I connect do SQL server
>> and execute one simple (1row) query.
>>
>> I use pgsql and mysql. tables and indexes are same for both
>> servers. So test table is identical
>>
>> Whe i execute those script i get some timing results
>>
>> PGSQL
>> Total time: 0.0576
>> Execution time: 0.0185
>>
>> MySQL
>> Total time: 0.0086
>> Execution time: 0.0028
>>
>> Time is in seconds.
>>
>> My machine is PIII 333 MHz with 128MB RAM. I table is only 3
>> rows of data.
>>
>> I want to know why is sucsh diference. Both servers runing
>> with socket connections and using connnect (non-persistant)