Performance improvement on PHP version upgrade?
Wed, 12/21/2011 - 10:36
I am not running tests on my machine to test improvements but ever since I upgraded from PHP version 5.2.X (I do not remember the 'X' part of the version) to 5.3.5, I can see a hell lot of improvement. I have a huge DB with complex schema which consists of 46 tables and about 10 tables in there have more than 40 columns. There are too many foreign keys and a lot many indexes as well.
When running codegen after schema change, the time taken on PHP 5.2.X was approximately 25 seconds. Now it takes only about 15 seconds. If running codegen second time (which effectively caches all DB catalog info in memory), the time taken has gone down from 15 seconds to 10 seconds. I think this is great.
Anyone else seeing the improvements?
And now with the PHP templates for coge generation and PHP 5.3.8, I am getting codegen on 62 columns (and a lot more sophisticated schema than before) done in about 20 seconds! Thanks to all those who worked on the change of templates and ported them to PHP based templates. Thanks :)
Regards,
Vaibhav