@John you are right I will download it ...
On Sat, Aug 8, 2009 at 8:10 AM, Brandon Betances <[email protected]>wrote: > Cache all the data in the application/web server and query that instead. > Poll the SQL server every few minutes or something for changes. > > 2009/8/7 ☺Aνιηαѕн ∂єѕαι™☺ <[email protected]> > >> Hi All >> >> I have a table where it has 45000 Rows of data and a Column Named >> Description will be used to search >> >> Just if user enters the Text like this *"Bailed out With"* >> Where i split the String and will build the Query String >> >> and Query will be like this Select * from CaseList where Description >> Like'%bailed%' or description like '%Out%' or description Like '%With%' >> >> This above Query Takes 15.6 Minutes to search data >> >> I think this can be solved by FullText Index search But i am using SQL >> Express...??? >> >> Can any one tell me what to do to search data very fast??? please let me >> know as soon as possible.. >> >> >> -- >> Thanks & Regards >> Avinash Desai >> *SAVE Nature SAVE Tree SAVE* >> >> Think Before you print: Please consider our environment before printing >> this e-mail >> >> Charles de >> Gaulle<http://www.brainyquote.com/quotes/authors/c/charles_de_gaulle.html> - >> "The better I get to know men, the more I find myself loving dogs." >> > > -- Thanks & Regards Avinash Desai *SAVE Nature SAVE Tree SAVE* Think Before you print: Please consider our environment before printing this e-mail Jonathan Swift<http://www.brainyquote.com/quotes/authors/j/jonathan_swift.html> - "May you live every day of your life."
