Hi Shane, Have you tried optimising the search itself?
(<cfcollection action="OPTIMIZE" ...) If this site has been accumulating stuff for a long time perhaps that would be a place to start? Regards, James > -----Original Message----- > From: Shane Farmer [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 1 February 2005 4:06 PM > To: CFAussie Mailing List > Subject: [cfaussie] Slow Verity Search > > > Hey, > > Has anyone had problems with a verity search taking 2 to 3 minutes to > search a collection? It is searching from an SQL Server database and > files on the server itself. The page has been profiled and the > cfsearch is the part of the code taking the time. > > This is old code that needs optimising. 3 minutes is not an acceptable > amount of time for a Verity search considering the site isn't overly > big. Any suggestions in speeding things up would be greatly > appreciated. > > Thanks, > Shane > > --- > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
