Fastest Search Results like Google ? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Fastest Search Results like Google ?

Hi Friends, I m developing a Online Job Portal. In this i need to a very very fast seraching technique. As usaully we used to send query to the databse and it retrive the databse and send back the result. but this whole porcess take time but as i see on may sites like google , yahoo they just give the result in fraction of seconds. So please help me and tell me what exact technique we should to make our serach as much fastest as we can….
I really need that plz help me. I know the capability of this forum members, you defiantly solve my query. MY development enviornment is : .Net
Database: Sql 2000 plz tell me the optimum to optimum way to retrival of data if i m going to use 4-5 table in join.
Thanks in advance..
FreeCoders Group

Why don’t ask Google & Yahoo how they achieve this [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />], just kidding.<br />You can build the SELECT statement based on the search criteria and refer<a target="_blank" href=></a> fyi.<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
Hi ya, be aware that places like Google and Yahoo not only spend millions on their technology, they also don’t use a SQL database for their searching. They will have high powered text search engines. In MS SQL there is a Full Text Search, but for anything of a larger size there are various purpose built search engines out there who for a price will speed up search performance. Cheers