2 Replies Latest reply on May 21, 2009 5:40 AM by chazman113

    cfqueryparam, caching and a pleasant surprise in 8, is it real?

    chazman113 Level 1

      I wanted to make sure my assumptions are correct,

       

      I have a cfc that runs a rather complicated query, the first time it runs it it can take almost a second, but caching obviously makes it run very fast. The query uses cfqueryparams for the 3 inputs that are variable. I would imagine the caching wouldn't really work because the inputs are changing all the time, but having put two function calls side by side, with different inputs, they BOTH run extremely fast. Can coldfusion 8 cache 2 queries with the same name (var scope in cfc) and DIFFERENT cfqueryparam inputs? If so, that is awesome

       

       

      Thanks in advance!