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.