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."
