Todd
This may not apply to your situation, but it is worth investigating.
Consider creating a shadow database (possibly denormalized) to
address the performance issue...
....organize the data to fit the specific processing requirements of
your most frequently used queries. Then take advantage of stored
procedures, caching, etc to reduce processing to the absolute minimum.
To the purists, this may be heresy. But if the success of the site
depends on the performance, it may be critical to depart from "pure"
database design tenets, waste some storage... but get the job done.
I am reminded of a quote from my years at IBM:
"A job worth doing, is worth doing poorly... if there is no other choice"
HTH
Dick
At 10:53 AM -0500 12/15/00, Todd Ashworth wrote:
>| 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
