What is cf_timer? Why not just print out CFQUERY.ExecutionTime ?
-David
On Mon, 27 Nov 2000 14:23:06 +1100 "Scott, Andrew" <[EMAIL PROTECTED]>
writes:
> I am a little confused on this, this is something I haven't dealt
> with
> much... So forgive me if I don't understand.
>
> Anyway I have done the following as a test.
>
> <cf_timer>
> <CFQUERY NAME="ASTest" DATASOURCE="anything"
> cachedwithin="#CreateTimeSpan(1,0,0,0)#">
> select * from bp_modules
> </CFQUERY>
> </cf_timer>
> <cf_timer>
> <CFQUERY NAME="ASTest" DATASOURCE="anything"
> cachedwithin="#CreateTimeSpan(1,0,0,0)#">
> select * from bp_modules
> </CFQUERY>
> </cf_timer>
>
> The intersting thing is that, sometimes the second query returns the
> time it
> should have executed other times it returns 0ms like you would
> expect a
> cache to return.... This to me appears that either the logic of how
> it works
> is wrong in what I think it does, or that there is a bug in the
> query
> caching.....
________________________________________________________________
GET INTERNET ACCESS FROM JUNO!
Juno offers FREE or PREMIUM Internet access for less!
Join Juno today! For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists