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

Reply via email to