Re: DB speed
| From: | Chris Hewitt | Date: | Thu, 10 Oct 2002 14:01:29 +0000 |
| Subject: | Re: DB speed | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-119528@lists.php.net to get a copy of this message | ||
Simon Taylor wrote:
Well obviously - cos MySQL rocks!!, but seriously I also did some tests and got variable results from different db's - even got an odbc connection to access to run faster than mysql at one stage!! - something tells me there are other factors contributing.. -----Original Message----- From: Uros Gruber [mailto:uros.gruber@sir-mag.com] Sent: 10 October 2002 14:17 To: php-general@lists.php.net Subject: [PHP] DB speed And i wan't to know if this is normal. PGSQL Total time: 0.0576 Execution time: 0.0185 MySQL Total time: 0.0086 Execution time: 0.0028 If the MySQL table is standard (not INNODB) then there are no transactions, thus is faster. I have not tried tests on these two databases in particular, but some (e.g. Oracle), cache results so a second time of asking can be very much quicker than the first.HTH Chris