If you are looking at where to focus your optimization efforts, start
with database queries. Do whatever you can to reduce the load on the
database and shrink the amount of data being sent back and forth. Also
make sure you have the proper database indexes set up.
In nearly every case where I am asked to help speed up Web sites, the
problem comes down to poorly designed databases or sub-optimal
database queries. Although increasingly I am seeing Web services as
being a bottleneck.
Good luck,
Mike Chabot
On Feb 18, 2008 6:52 PM, Don L <[EMAIL PROTECTED]> wrote:
> ok, let's try some {Big Areas} first and then try to nail down each branch.
> I type as I think...
> * cf coding...
> e.g. a)technique one,
> <cfif cond1 ... AND cond2 AND cond3...> ... </cfif>
> vs.
> <cfparam name="c" default=0>
> <cfif cond1 ...> <cfset c = c + 1> </cfif>
> <cfif cond2 ...> <cfset c = c + 1> </cfif>
> <cfif cond3 ...> <cfset c = c + 1> </cfif>
> <cfif c eq 3> ... </cfif>
>
> using CFC whenever feasible...
>
> * db design / query optimization...
> e.g. a) instead of using the OR operator use UNION,
> select * from tbl
> where cond1 = 'this'
> OR cond2 = 1
> OR cond3 LIKE '%thisValue'
>
> vs.
> select * from tbl
> where cond1 = 'this'
> UNION
> select * from tbl
> where
> cond2 = 1
> UNION
> select * from tbl
> where cond3 LIKE '%thisValue'
> ....
>
> * cf server optimization...
>
> > You can pull out some of the unneeded files, but I cannot imagine
> > that
> > this would speed up the site in any measurable way, especially if you
> > aren't using those unneeded features to begin with. There are so many
> > other things that can be done to speed up a server or a Web site that
> > I doubt too many people have taken a look at this approach.
> >
> > -Mike Chabot
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299315
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
