Re: [nyphp-talk] Performance testing on Windows Server 2008 & MySQLi performance hit

2012-07-03 Thread Daniel Convissor
Hi Woh: > The tool you mentioned is for Apache servers, we are on IIS 7. The ab tools make request to the website using HTTP. You can use it to test any web server, not just Apache HTTPD servers. --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data in

Re: [nyphp-talk] Performance testing on Windows Server 2008 & MySQLi performance hit

2012-07-03 Thread Daniel Convissor
Hi Woh: > 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. The way files are included can be a significant performance issue. It's best to us

Re: [nyphp-talk] Performance testing on Windows Server 2008 & MySQLi performance hit

2012-07-03 Thread Woh Roh
Anthony, We didn't touch the mysql driver. Only upgraded php. On Tue, Jul 3, 2012 at 3:48 PM, Anthony Ferrara wrote: > Faltu, > > On Tue, Jul 3, 2012 at 3:45 PM, Woh Roh wrote: > >> Hi Anthony, >> I forgot to mention, with the upgrade, we also moved from php 5.3 to >> 5.4. We are using mysqln

Re: [nyphp-talk] Performance testing on Windows Server 2008 & MySQLi performance hit

2012-07-03 Thread Anthony Ferrara
Faltu, On Tue, Jul 3, 2012 at 3:45 PM, Woh Roh wrote: > 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 $. > That's a difference ;-) Were you using mysqlnd before hand (under 5.3)? Or were you

Re: [nyphp-talk] Performance testing on Windows Server 2008 & MySQLi performance hit

2012-07-03 Thread Woh Roh
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 wrot

Re: [nyphp-talk] Performance testing on Windows Server 2008 & MySQLi performance hit

2012-07-03 Thread Anthony Ferrara
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 a

Re: [nyphp-talk] Performance testing on Windows Server 2008 & MySQLi performance hit

2012-07-03 Thread Donald Organ
1) http://httpd.apache.org/docs/2.0/programs/ab.html This handy tool will let you run some loads tests 2) We're the standard mysql connections using persistent connections, also have you though about using mysqlnd? On Tue, Jul 3, 2012 at 3:14 PM, Woh Roh wrote: > Hi All, > I have two questi

[nyphp-talk] Performance testing on Windows Server 2008 & MySQLi performance hit

2012-07-03 Thread Woh Roh
Hi All, I have two questions- 1) A client has requested that their virtual server be upgraded from 1gb to 2gb ram so that the application runs faster and can handle more users. Before upgrading the server, I want to run performance tests to measure the before / after effects. Which tool would you