Posted by J.O. Aho on 06/15/07 03:55
cluthz wrote:
> As maybe mentioned in some previous postings I had some problems going live
> with no code. Performance seemed to suffer.
>
> But actually now I run the same code on live and test and the test server
> seems much faster. This is running a version of MySQL 3 and the live server
> (a different hosting company) is running version 4.
>
> Could the sql version be the reason for the, say 30% speed reduction?
Mysql4 is by default faster than mysql3 server, and mysql4 has more features
than mysql3. So there is some other reason for the difference, like the
computing power on the machines or a lagtime between you and the servers, ...
--
//Aho
[Back to original message]
|