Hi Anthony, I forgot to mention, with the upgrade, we also moved from php 5.3 to 5.4. We are using mysqlnd 5.0.10 - 20111026 - $Revision: 323634 $.
Donald, The tool you mentioned is for Apache servers, we are on IIS 7. Thanks for your help. On Tue, Jul 3, 2012 at 3:32 PM, Anthony Ferrara <ircmax...@gmail.com> wrote: > Faltu, > > 2) Part of the reason for upgrading is that the application has taken a >> HUGE hit in performance after we updated mysql connections to mysqli and >> moved most of the php files above the web root folder. I researched online >> for performance hits after moving to mysqli but no where found anyone >> discussing such a drastic setback. With xdebug, I see the mysqli >> connections are the culprit and perform 2-4 times slower than before. When >> testing with the PHP MySQL Benchmark Tool v. 0.1 ( >> http://unbeknownst.net/?p=321) scripts, I don't see a big diff between >> mysql and mysqli queries. Anyone else seen this issue?? >> > > I haven't. What version of PHP are you using? And which driver are you > compiled against (libmysql, mysqlnd, etc)? Are the mysql and mysqli > differences on the same compile of php on the same machine? Or are they on > different boxes? > > Anthony > >
_______________________________________________ New York PHP User Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/show-participation
