RE: [CFCDev] CFC Performance question

[Andy Ousterhout]

My question wasn't whether CFC's have inherent performance issues but rather at what point in time does one need to review ones code and perhaps tradeoff some user-friendly features for better performance.  Is it at 300ms for larger CFC's, 500, ....

 

I know that I can improve performance in several ways, but like the usability that I get from the current design.  Question is can I afford the, IMHO, more elegant design to streamline performance.

 

Andy 

 

 -----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Joe Eugene
Sent: Sunday, November 09, 2003 3:58 PM
To: [EMAIL PROTECTED]
Subject: RE: [CFCDev] CFC Performance question

As far as i Know, there are NO Performance Problems with CFC's,

it might rather be your implementation.

 

You can accomplish some things without an SP as well...

e.g

Your query to check products can change to

select whatever from TableName where PRD_ID in ('PD101,PD102');

 

Now, you can pass one or more products to the method to validate...

instead of running the method or query in a loop.

 

You can also store the order in the session scope/xml/wddx and populate

the Order only on completion of the order.

 

Joe Eugene

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Andy Ousterhout
Sent: Sunday, November 09, 2003 4:16 PM
To: [EMAIL PROTECTED]
Subject: RE: [CFCDev] CFC Performance question

Correct.  With Access, I can't use stored procedures(as far as I know), so right now, each product being added to the order results in a DB read.  

 

In some cases, this will still be necessary (User enters Product ID and the system will need to look up description and price.  If the product is added to the order off of a listing(the likely case for all Internet Retail orders and most internet wholesale and retail/wholesale telephone orders), then all of the information can be passed to the method and a DB lookup will not be required.

 

I am still curious, however, when the performance of a CFC starts to become an issue or when a programmer should consider design alternatives for high volume objects that may substitute better performance for perhaps some reduced usability. 

 

 

 -----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Joe Eugene
Sent: Sunday, November 09, 2003 2:42 PM
To: [EMAIL PROTECTED]
Subject: RE: [CFCDev] CFC Performance question

It depends on what you are doing in your addItem() Method. If you are making

DB calls to Verify Every Single Product Or Pass a array/other to the Products Verify

which makes only one call to the DB.

 

You probably are making Multiple calls to the Database. You can check all products

with one call to the DB, perhaps using a Stored Procedure.

Joe Eugene

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Andy Ousterhout
Sent: Sunday, November 09, 2003 2:48 PM
To: Cfcdev
Subject: [CFCDev] CFC Performance question

I have a CFC that processes sales orders.  It has a Customer.cfc and Product.cfc to validate each of these properties.  On my dev machine, it took 591ms to create and save 1 order with 5 items.  Should I be satisfied with this performance or should I look at ways to improve this?  The majority of this time was in the 5 calls to the  AddItem method which has a product CFC verify item information, with the first call taking 80ms, then 50ms, 50ms, 30ms and 30ms.

 

I am using an Access DB and am in the process of moving to MS SQL 2000.  Should this improve performance?

 

Andy