> 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.
FYI - The MaxRows attribute of the CFQUERY tag is applied AFTER the dataset has been returned to CF. If you want to only retrieve the first 10 rows, you are better off using the TOP keyword ie: SELECT TOP 10 name, phone, etc FROM... -Cameron -------------------- Cameron Childress elliptIQ Inc. p.770.460.1035.232 f.770.460.0963 -- http://www.neighborware.com America's Leading Community Network Software > -----Original Message----- > From: Declan Maher [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 02, 2002 11:59 AM > To: CF-Talk > Subject: RE: Speeding up select queries > > > 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. > > > ______________________________________________________________________ Get Your Own Dedicated Windows 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=coldfusionb 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