Hi All, I am using db.search method for searching documents…The database contains about 50 thousand documents and database is not indexed. When I am using this method it takes so much time to execute it…my question is if i index the database will it be faster to execute the db.search formula???
Regards,
Shankar.
Subject: Take a look at this article…
It contains some good information.
db.search is actually fairly efficient for searching, but it depends on hwo complex your search formula is.
Subject: db.search
It would be better if you used db.FTSearch()and you would have to index the DB
and yes it would be faster
Subject: double click - please ignore
Subject: RE: db.search
The only other option is to build a view containing the documents you search for in advance.