MySQL 4.1.x vs 4.0.x

Is there any real advantage to installing MySQL 4.1.x over 4.0.x if the scripts are not specifically optimized to 4.1?

4.0 has query caching and that seems like the real benefit of the 4.x series. 4.1 introduces Subqueries, but if we are using scripts written to be compatible with MySQL 3.23, will we see any benefit of 4.1 over 4.0 ?

Thank you,

 

 

 

 

Top