How to improve performance of Adodb library in PHP?
Posted on 2008-09-29
We were using Adodb in the backend of our enterprise application.
When we started testing we noticed that with 2000 requests made simultaneously,
CPU usage on server is 99.6% which is very high and also error rate is high.
But when we do the same testing using the builtin mysql commands in PHP,
CPU usage on server is less than 26%.
The ADODB abstraction library is drastically decreasing the performance. Can anyone suggest tweaks to improve the performance of ADODB because we cannot remove ADODB from our application.
We tried some tweaks suggested in internet but it did not work.
Reply as soon as possible.