1. Re: MySQL performance [was: odbc resources]
Alex Chamberlain wrote:
>
> A wrapper for the MySql library would be more useful here, because when I use
> php connected via the library, its faster than 15/sec.
>
> Alex
I am currently optimizing a site build on PHP and MySQL. The database size is
120 Gigabytes. The largest table has 13 million rows, and the database has more
than 40 million rows.
This site was not designed by me and it was not functional due to its size and
PHP code. I have been using Euphoria and my own MySQL wrapper to make changes to
structure and data. Now, with PHP, queries are run under one second.
The MySQL wrapper built with Euphoria is slightly faster than the one from PHP
and Euphoria runs between 10 to 30 times faster than PHP on other tasks than
MySQL, depending on the tasks involved.
MySQL updates 18.000 records per second in these tables .
MySQL speed is impressive and if you join it with Euphoria...
JG
