RE: do stored procedures REALLY .... - caching sproc results

2000-07-27 Thread Howarth, Craig
t the table or view. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 27, 2000 11:27 AM To: [EMAIL PROTECTED] Subject: RE: do stored procedures REALLY .... - caching sproc results Except CF doesn't just cache the results, it has to cac

RE: do stored procedures REALLY .... - caching sproc results

2000-07-27 Thread mherbene
.. -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 27, 2000 11:15 AM To: [EMAIL PROTECTED] Subject: Re: do stored procedures REALLY .... - caching sproc results > One way in which stored procedures called using CFSTOREDPROC _could_ result > i

Re: do stored procedures REALLY .... - caching sproc results

2000-07-27 Thread JustinMacCarthy
> One way in which stored procedures called using CFSTOREDPROC _could_ result > in a performance loss is that CF can't cache their results. I agree that I always wonder why is this ?? Surely how ever the query is executed , cf still ends up with a RecordSet?? Why can't cf cache results from a S