I introduced him to the big bad world of contains :)
-----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 28 October 2003 16:14 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] VARCHAR searches First off....as you know...a LIKE search will be slow as hell, that's just the nature of that type of search... Try and update your tables statistics and see what kind of performance increase it gives you. Also, If its not already...throw the query into a Stored Procedure and begin to use SQL HINTS on it and you will find that with small tweaks you can begin to glean performance benefits.. -----Original Message----- From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED] Sent: 28 October 2003 15:31 To: [EMAIL PROTECTED] Subject: [ cf-dev ] VARCHAR searches I have a table in a BIG database where I need to search on a varchar field like this Select * from table Where company_name LIKE '%#form.company_name#%' But it is slow as hell. Every thing else is running at a decent speed, on direct comparisens and even if I do a LIKE '#form.company_name#%' it is fast enough. I have indexes and a ful-text catalog, ios there any other way to speed up such a query ? Russ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.532 / Virus Database: 326 - Release Date: 27/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.532 / Virus Database: 326 - Release Date: 27/10/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
