Re[2]: [PEAR] DB class speed

From: 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)

« previous php.pear.general (#2474) next »