Re: [CFCDev] CFC Performance question

[Matt Liotta]

Database queries take most of this time.  I wonder how much this will
change(hopefully improve) when I complete the move from Access to MS 
SQL.

I'm sure things will improve with MS SQL. However, the difference is 
the greatest when there are many simultaneous requests.

I wonder if I am in for some heartache as usage picks up.  Or perhaps 
the
better question is how many users will it take before I get the big
performance hit.

It all depends on what your performance requirements are.

Is this 100ms number primarily for dynamic pages or do you apply this 
to
transactions as well?

I apply this rule to all page requests.

Matt Liotta
President & CEO
Montara Software, Inc.
http://www.MontaraSoftware.com
(888) 408-0900 x901
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email
to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' 
in the message of the email.

CFCDev is run by CFCZone (www.cfczone.org) and supported
by Mindtool, Corporation (www.mindtool.com).
An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]