Is there any way you could consolidate the queries, ie find some common
ground to perform a join on?
--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC 28270
www.solutionmasters.com
704.563.5559 x 228 Voice
704.849.9291 Fax
-----Original Message-----
From: Todd Ashworth <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Date: Friday, December 15, 2000 11:06 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
