SQL Server Performance

Fastest Search Results like Google ?

Discussion in 'Non-Transact SQL Developer Performance Tuning' started by abhinavgoyal, Oct 6, 2006.

  1. abhinavgoyal New Member

    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..
    Abhinav
    FreeCoders Group
  2. satya Moderator

    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=http://www.sql-server-performance.com/asp_sql_server.asp>http://www.sql-server-performance.com/asp_sql_server.asp</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>
  3. Twan New Member

    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
    Twan

Share This Page