RE: [CFCDev] CFC Performance question

[Joe Eugene]

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