Ive had to take a look at the way we code everything on our apps we build and ive found that when on our production machine the execution time can be very slow.
ive taken a step of attempting to speed things up and have cached all the cfc's within the application scope using the following.
<cfif NOT StructKeyExists(application,'components')> CREATE THE CACHING OF THE CFC'S </cfif>
when i load the pages up initially in 1 browser it appears to be quite slow, in that the page averages over 1000 ms. when i refresh the page it loads up alot quicker around the 100 milisecond range.
I know that without seeing the structure of the application or the queries behind it, what could possibly be making it slower.
Would it be advisable to rewrite the queries or create them as storedprocs and let the DB handle the load of the query ?
We are currently using Fusebox 4.1 still and cant really change that as the applications are quite large
That is because on first load it has to load the objects.. then it's loading as "cache"... at least that is what it sounds like... We'd need more information to properly identify a solution; but look into the caching route.
Pablo Varando Senior Application Architect EasyCFM.COM, LLC.
thenamenoonehas
11-30-2011 @ 8:19 PM
