Searching in ASP

hi everybody,

i want to perform search operations using ASP.

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

 

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.

 

thanx a lot for the guidance