I think there is some big misunderstanding about the traffic here. If your query is CACHED, then CF will not contact the MySQL server again until that cache has expired, and then it will only do it once and re-cache the query. So whatever is causing your network traffic, it is not CF connecting to MySQL Additionally port 51011 has nothing to do with Mysql, all mysql connections by default happen opn port 3306 As I believe was explained previously, port 51011 is the JRUN internal proxy port, so unless you have CF and the web server in different physical servers, this would not cause any network traffic.
Also using a flat file will make no difference to that traffic as it is the web server connecting talking to jrun, which is required. On Fri, Sep 7, 2012 at 1:42 PM, Steve LaBadie <[email protected]>wrote: > > This question is in relation to a previous post I made about a lot of > request through port 51011. Was able to resolve a lot of the traffic by > caching. We are using a MySQL database and MX7 with an include file on > the home page which calls this file: > > > > <cfquery datasource="admin_panel" name="etext" > cachedwithin="#createTimespan(0,0,1,0)#"> > > SELECT * > > FROM emergency > > WHERE active = 1 > > LIMIT 1 > > </cfquery> > > <cfloop query="etext"> > > <section class="grid_11 push_4 mainContent" > id="emergency"> > > <img src="/images/icons/template/exclamation-icon.png" > id="emergencyIcon"/> > > <h2><cfoutput>#etext.title#</cfoutput></h2> > > <cfoutput>#etext.text#</cfoutput> > > </section> > > </cfloop> > > > > The traffic has reduced a lot but my System Admin is request that I use > a Flat File to reduce traffic even more. Never used a flat file before > or how CF would handle it. Any guidance would be appreciated. > > > > Steve LaBadie, Web Manager > > East Stroudsburg University > > 570-422-3999 > > [email protected] > > > > <http://www.facebook.com/eaststroudsburguniversity> > <http://twitter.com/esuniversity> > <http://www.youtube.com/user/esuedu> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:352448 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
