.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> ASP.Net >> Post New QuestionBookmark and Share Subscribe to Forum

Fast search in asp.net

Posted By: Ruchi     Posted Date: May 02, 2009    Points:2   Category :ASP.Net
How can i use various algorithms to provide a fast search to the users? I use 3 tier architecture.

Responses
Author: Akhil Raj       [Moderator]      
Posted Date: May 04, 2009     Points: 5   

hi,

i didn't get your question correctly. Are you ask about searching algorithms. IF i am correct please check the following link for searching algorithms

http://en.wikipedia.org/wiki/Search_algorithm


Author: Ruchi             
Posted Date: May 05, 2009     Points: 5   

hi Mr Akhil,

I will modify my ques.

If i pass a select query with many where conditions then it may take time to process. So i was thinking of an alternative to apply search algorithems on a simple select query to get the required output. will the above solution work? and how can i implement it?

Author: Vuyiswa Maseko             
Posted Date: May 08, 2009     Points: 5   

Good Afternoon Akhil Raj

This is a Very Simple Question, but we need to understand first how you search and we need to see your SQl Query that you are using to search and lastly i have one question,

Does the table you search have indexes ?

Does the Field included in where Clause part of the Index ?

Do you Return only the Fields that you want or you return unwanted data ?

I think from my questions you can find the Solution , if you did not then contact me

Vuyiswa Maseko



Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend