Am working on a .Net web application which uses SQL server 2008 as database.
Its a "Job search" application through which end users can search for a job in my database using comma separated search keywords.My database could be having tens of thousands of jobs.Each job would have a title and a description.
I need to return all the matching jobs to the user based on his search criteria and also give an appropriate "rating" for each job with respect to the percentage of matched keywords found.Users would have a feature of sorting the returned jobs results on "Rating","Date posted", etc.
I guess, using a sql cursor in the stored procedure to loop through each matched job and then calculating & assigning rating to each job would be pretty resource intensive..more so, if the number of records are too high.
So, any ideas on how to go about efficiently designing this kind of application?...how do i optimally search and fetch all the relevant records alongwith "rating" from the database without having a significant performance hit??
Any help would be greatly appreciated!:)
Thanks.
Simon.