queries. You can also set the log setting to log the long running queries.
One of the biggest challenges to ColdFusion developers is to learn enough SQL to
avoid huge queries when supporting a data driven web site. There are more posts
on this list describing HUGE numbers of records returned from a query and then
having to do sub-queries to actually extract the records with which to display a
page for display in the browser. It is just not a good practice to force the
server to churn, loop, etc in the process of returning a page of data. The
effort would be better spent in learning and practicing optimized quires in the
first place. With good indexing practices, and the right query, a page of data
can be very fast to load and display, and make your web site hum along even with
a large number of simultaneous users.
======================================
Stop spam on your domain, Anti-spam solutions
http://www.clickdoug.com/mailfilter.cfm
For hosting solutions http://www.clickdoug.com
======================================
Aspire to Inspire before you Retire or Expire!
----- Original Message -----
From: "Robert Bailey" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, January 24, 2004 12:32 PM
Subject: RE: 2003 server and CFMX
: If they are not timing out in a timely fashion, how can I fix that? Looking
: at the logs now.
:
:
: ________________________________
:
: From: Doug White [mailto:[EMAIL PROTECTED]
: Sent: Saturday, January 24, 2004 1:30 PM
: To: CF-Talk
: Subject: Re: 2003 server and CFMX
:
:
: Check your error logfiles. Sounds like there are some long running
: processes
: that are not timing out in a timely fashion.
:
: ======================================
: Stop spam on your domain, Anti-spam solutions
: http://www.clickdoug.com/mailfilter.cfm
: For hosting solutions http://www.clickdoug.com
: ======================================
: Aspire to Inspire before you Retire or Expire!
:
: ----- Original Message -----
: From: "Robert Bailey" <[EMAIL PROTECTED]>
: To: "CF-Talk" <[EMAIL PROTECTED]>
: Sent: Saturday, January 24, 2004 12:18 PM
: Subject: 2003 server and CFMX
:
: : Is anyone having any problems running CFMX, either JRUN installed or
: default
: : installation as a filter? We seem to keep having problems with the ODBC
: : server dropping and JRUN dying on us a few times a day. We are running IIS
: : 6, Windows 2003 server, and CFMX with the latest update. Any feedback
: would
: : be appreciated.
: :
: :
: :
: ________________________________
:
:
:
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
