1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Searching in ASP

Discussion in 'C#' started by vijaykoul, Jan 23, 2005.

  1. #1
    hi everybody,

    i want to perform search operations using ASP.
    SEMrush
    this is a word search i.e. every word entered as search keyword
    should be searched in the database...

    since it is a word search, i tried to split the string entered as search keyword,
    and then search for each splitted word in the database.
    It worked for only a few records present in the database.
    some 1034 records were searched out of 1914
    i tried the same procedure in PHP and that worked.

    can anybody help me and tell me the best way to perform this kind of search

    i will be highly thankful
     
    vijaykoul, Jan 23, 2005 IP
    SEMrush
  2. J.D.

    J.D. Peon

    Messages:
    1,198
    Likes Received:
    64
    Best Answers:
    0
    Trophy Points:
    0
    #2
    It sounds that you need full-text search functionality. This kind of search is completely different from a relational search you are trying to implement. For example, if you have a text field that contains more than one word, indexing such column will only give you good performance for queries that begin with a certain sequence of characters (i.e. using an index for this column). If you use the LIKE predicate, your DBMS server will have to scan every record in the table - no index will be used in this case.

    For file system searches you can use MS' Indexing Server. It's very fast and indexes files almost instantaneously. SQL Server supports full-text searches as well. MySQL will support this functionality in v5.

    J.D.
     
    J.D., Jan 24, 2005 IP
  3. vijaykoul

    vijaykoul Guest

    Messages:
    43
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thanx a lot for the guidance
     
    vijaykoul, Jan 26, 2005 IP