Re: Advice about query caching

Thanks everyone for your input. - Paul > Hello everyone, > > First post here, so don't get too hard on me. > > I'm developping a small e-commerce application with less than 1000 > products ( around 700). > As far as I know, only product prices would be updated on a weekly > basis. > > I'm no

Re: Advice about query caching

I fully agree. Do you know of any good tools for memory metrics ? >It would need some memory metrics against it I suppose - what would be more >efficient: a large 700 resultset residing in memory all the time or X amount >of calls asking for said query on each request (it is required) which >resid

Re: Advice about query caching

Here is a quick shot of what I wanted to do, in its basic form. application.objCfc = createObject("component", "#variables.componentsPath#.myCfc"); application.categories = application.objCfc.fnGetCategories(); application.products = application.objCfc.fnGetProducts(); I could after th

Re: Advice about query caching

this helps. > > >Doug B. > > >- Original Message - >From: "Paul Boyd" <[EMAIL PROTECTED]> >To: "CF-Talk" >Sent: Sunday, November 12, 2006 4:05 AM >Subject: Advice about query caching > > >> Hello everyone, >> &g

Advice about query caching

Hello everyone, First post here, so don't get too hard on me. I'm developping a small e-commerce application with less than 1000 products ( around 700). As far as I know, only product prices would be updated on a weekly basis. I'm not too sure how to handle caching. So here is my question. Is