In addition to Sandys rules of thumb, I would convert any query you have into a stored procedure. One of the added benefits is that you can have multiple result sets when using stored procs. Also, index columns that are frequently accessed and/or columns you use in your where clause.
Mark -----Original Message----- From: Sandy Clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 11:43 AM To: CF-Talk Subject: RE: Speeding up select queries General rules of thumb I use. Avoid Select * always specify your fields. Fastest is to select fields in the following datatype order, integers, numeric, strings according to field size. Memo or Long text fields are always last. The latter one is most important because all fields selected after a long text field will load as unbound fields and will slow the sql way down. -----Original Message----- From: Tracy Bost [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 11:22 AM 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
