Other attributes of <cfquery> which may be of help in speeding up a query is to try using <blockfactor>whick specifies the max number of rows to fetch at a time from the server or <maxrows> if you want to limit the number of rows returned.
Regards, Declan -----Original Message----- From: Tracy Bost [mailto:[EMAIL PROTECTED]] Sent: 02 January 2002 16:22 To: CF-Talk Subject: Speeding up select queries What is the best approach to speed up "select" statements with a sql2000 database? The data is constantly being updated,deleted,inserted, through out the day with each user seeing data depending on his/her access level and assigned zip codes. I worry that using cachedwithin will not work in this senario, as using that will not allow to show data that has recently changed. ANY help, thoughts much appreciated. ------------------------------------------------------------------------- ----- Visit "The Most Powerful Tool on the Farm" at http://www.ifarm.com Get the latest on Ag News, Market Reports, FREE email, and much more. ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists