1) Set up a server in a development area. Make sure noone else is using it.
2) Restart it to clear out any random memory buggers.
3) Start Perfmon and watch memory usage.
4) Start running your cached queries one at a time.
5) Compare memory usage to what your "big man" thinks is reasonable.
6) No argument required. Simply make a decision.
-Cameron
--------------------
Cameron Childress
ElliptIQ Inc.
p.770.460.7277.232
f.770.460.0963
> -----Original Message-----
> From: Todd McFarlin [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 18, 2000 1:08 PM
> To: CF-Talk
> Subject: CFQuery and Caching
>
>
> Greetings all,
>
> I am new a this project and the current methodology doesn't utilize
> query caching. I attempted to make an argument, but could not satisfy the
> big man's concerns of memory consumption.
> The project is an app, so I cannot quote the configuration that
> it will run
> on.
> The largest query result would pull 1000 rows*15 columns.
> Can any offer advise to an argument? Pro or Con:
>
> TIA,
> Todd
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
