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]
