> Can anybody tell why this query is taking SEVENTEEN SECONDS > to run? I'm looping through a bunch of form variables, and > this query is taking 12 to 14 seconds every time (but this > first time) to run. I'm running SQL Server and CF Server > off my laptop, but it didn't started running this slow until > lately. Updating to SQL Server SP2 had no effect.
Nothing within the query struck me as an obvious problem (although I didn't read it that carefully). My two suggestions are: 1. Use the debugging information that SQL Server provides. Run the query from within Query Analyzer, and set SHOWPLAN options or use the graphical execution plan display in SQL Server 2000. 2. Take a look at your indexes. Have you created indexes that will best suit your search queries as the amount of data grows larger? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ 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
