Todd:

Try using as much SQL instead of using CF to do some of that looping or
processing that is taking a lengthy amount of time.

Also check to see if using cached querries could help.

-Greg
----- Original Message -----
From: "Todd Ashworth" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, December 15, 2000 10:53 AM
Subject: Re: how many milliseconds is too many?


> | However, 3.6 seconds is a lengthy time for a page to be processing.
>
> Yes, it is.  That's why I was concerned about how much of an impact it
would
> have on the application and the server once users started using it for
real.
> I would hate to lauch the site and then have it die pitifully under normal
> use and have to go back a do a rewrite.
>
> The page pulls data from 6 different tables and performs several loops in
> the process.  Unfortunately, I can't figure out how to make it go any
> faster.  I'm sure a stored procedure would help, but it was all I could do
> to get it written in CF, heh.
>
> Todd Ashworth
>
> ----- Original Message -----
> From: "Greg Wolfinger" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, December 15, 2000 10:21 AM
> Subject: Re: how many milliseconds is too many?
>
>
> | Todd:
> |
> | It all really depends.  You can't accurately determine the number of
users
> | until your server will crash.  It all depends on what the page is doing
> and
> | such.  However, 3.6 seconds is a lengthy time for a page to be
processing.
> |
> | -Greg
> | ----- Original Message -----
> | From: "Todd Ashworth" <[EMAIL PROTECTED]>
> | To: "CF-Talk" <[EMAIL PROTECTED]>
> | Sent: Thursday, December 14, 2000 7:33 PM
> | Subject: how many milliseconds is too many?
> |
> |
> | > Say I have a page that takes about 3,600 ms to process.  Does anyone
> know
> | > how much traffic that page can handle before killing the server .. or
at
> | > least until the app becomes unusable?
> | >
> | > Todd Ashworth
> | >
> | >
> | >
> | >
> |
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to