and we do not have any control over the content that other developers use.
------------------------------------
________________________________
From: Doug White [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 24, 2004 4:16 PM
To: CF-Talk
Subject: Re: 2003 server and CFMX
In CF administrator, you can shorten the setting for terminating long
running
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]
