Re[2]: [PEAR] DB class speed
by Uros Gruber other posts by this author
Oct 10 2002 8:32PM messages near this date
Re: [PEAR] DB class speed
|
[PEAR] script to test PEAR installation
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@[...].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)
--
PEAR General Mailing List (http://pear.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thread:
Uros Gruber
Martin Tsachev
Uros Gruber
|