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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
