For giggles, I just tried this on my box and got: HTML 33 milliseconds (static DataTime stamp and no queries to DB) CF 2910 milliseconds (cleared template cache and newly restarted CF service) CF 707 milliseconds (after above run)
And here's the code I tested. NOTE: only needed two cfdumps to get to 50K page size: <cfset count = 10> <cfoutput>#Now()#</cfoutput> <cfquery name="Q_GetData" datasource="thedatasource"> select top #count# * from table1 </cfquery> <cfdump var="#Q_GetData#"> <cfquery name="Q_GetData" datasource="thedatasource"> select top #count# * from table2 </cfquery> <cfdump var="#Q_GetData#"> <cfquery name="Q_GetData" datasource="thedatasource"> select top #count# * from table3 </cfquery> <cfquery name="Q_GetData" datasource="thedatasource"> select top #count# * from table4 </cfquery> <cfquery name="Q_GetData" datasource="thedatasource"> select top #count# * from table5 </cfquery> On Tue, Oct 19, 2010 at 3:29 PM, Ketan Jetty <[email protected]> wrote: > > This can lead to lots of controvertial posts. I did some performance > testing long back between HTML, CF, PHP, ASP.NET and Java. The benchmark > was a static HTML page and everything was measured against the performance > of HTML. Criteria used in the benchmarking was to generate a datetime stamp, > results from 5 queries to DB and a 50K page size > > The performance results matrix is given below: > HTML 100% (static DataTime stamp and no queries to DB) > PHP 90% of HTML > ASP.NET 80% of HTML > JAVA 75% of HTML > CF 40% of HTML [but I can say that CF is slowly improving] > > These are my findings and may change from time to time. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338342 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
