which application is bottlenecking things, and perhaps a polite note to the
client will encourage them to fix things. The other option is to time out those
long running queries, and the errors he will start getting will force him to fix
his code. :-)
======================================
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 3:48 PM
Subject: RE: 2003 server and CFMX
: Thanks Doug. I personally know SQL very well, but these are hosted domains
: 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]
