Title: Performance
Thread: Performance
Forum: Discussions
Conference: ColdBox
User: daemach We're attempting to use coldbox as a backend for Ext. Ext stores like to handle
loading themselves, so there are a lot of ajax requests going on for any
particular page load.
The problem is that the load times for these components
are huge. Where should we start looking to improve performance?
I'm doing
the following in main.onRequestStart:
<cfscript>
getController().setSetting("DebugMode",false);
event.noRender();
</cfscript>
A typical event handler looks like this:
<cffunction
name="getAvailableZipCodes" access="remote" output="false">
<cfargument
name="StateFIPS">
<cfquery name="getAvailableZipCodes"
datasource="#application.dsn#">
SELECT DISTINCT ZIPCode AS Display, ZIPCode
AS Value
FROM vw_AvailableRegionZIPCodes
<cfif
isDefined('arguments.StateFIPS') and arguments.StateFIPS neq 0>WHERE StateFIPS =
<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.StateFIPS#"></cfif>
ORDER BY zipCode
</cfquery>
<cfreturn getAvailableZipCodes>
</cffunction>
Those queries are very fast by themselves since they are coming
from views.
POST http://www2.missionincrease.org/admin/coldboxproxy.cfc
(484ms)ext-basex.js (line 378)
POST
http://www2.missionincrease.org/admin/coldboxproxy.cfc (578ms)ext-basex.js (line
378)
POST http://www2.missionincrease.org/admin/coldboxproxy.cfc
(1610ms)ext-basex.js (line 378)
POST
http://www2.missionincrease.org/admin/coldboxproxy.cfc (3797ms)ext-basex.js
(line 378)
POST
http://www2.missionincrease.org/Admin/index.cfm?action=general.getBranchList
(1156ms)ext-basex.js (line 378)
POST
http://www2.missionincrease.org/admin/coldboxproxy.cfc (1125ms)ext-basex.js
(line 378)
POST http://www2.missionincrease.org/admin/coldboxproxy.cfc
(1172ms)ext-basex.js (line 378)
POST
http://www2.missionincrease.org/admin/coldboxproxy.cfc (1141ms)ext-basex.js
(line 378)
POST
http://www2.missionincrease.org/Admin/index.cfm?action=general.getBranch (344ms)
http://www.luismajano.com/forums/index.cfm?event=ehMessages.dspMessages&threadid=5C7F0DF0-FF65-CEF6-65038D3C53B3A66D