Re: DB class speed
| From: | Martin Tsachev | Date: | Thu, 10 Oct 2002 13:13:39 +0000 |
| Subject: | Re: DB class speed | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-2471@lists.php.net to get a copy of this message | ||
Hi Uros,
I've also run some tests to see the speed difference and it was below
2%. It probably means that you've misconfigured something.
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)
--
Martin Tsachev
http://martin.f2o.org