cutoulously
New Member
I am currently working on a module, searching. It involves multiple conditions like name, experience from, experience to, salary range, technology etc., maybe 10 - 15 conditions. In each row of table it has 36 columns and having database of 4,00,000 records. Now, I have implemented normal conditional search which takes much more time and not getting proper output.Could anyone suggest me a better search algorithm or methodology? The application is build on by ASP.NET 4.0, C# 4.0 and database SQL Server 2008, Visual studio 2010.