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