March 8, 2008 at 4:53 am
What is the difference between dtSearch and Full Text search?
where it will be used?
March 8, 2008 at 8:07 am
Based on visiting http://www.dtsearch.com it appears that dtSeach indexes and searches documents on your PC/Network. Full Text Search is a SQL Server Feature that allows you to do search on text like 'Dog near Cat', not sure my syntax is correct.
Full Text Search allows you to search for:
* Two words near each other
* Any word derived from a particular root (for example run, ran, or running)
* Multiple words with distinct weightings
* A word or phrase close to the search word or phrase
Taken from http://www.developer.com/db/article.php/3446891
You can check out BOL as well.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 9, 2008 at 3:40 pm
Full text search search column data in SQL server. This will only search documents if you import documents into SQL server.
I do not know much about dtsearch but based on Jack's post, I would say that dtsearch uses the same logic as a Windows search. dtsearch seems to enhance the built-in Windows search functionality; however, you can do the same thing by searching a folder or drive and telling Windows to search for key words inside files.
Like I said before, I really have not used dtseach, but I am fairly confident that dtsearch does not offer the same search capabilties as a Full Text Search.
In addition to Jack's list of features, full text search also has these features:
-Noise word filtering (the, a, etc..)
-This also allows custom noise words.
-Thesaurus support for like words
-accent insensitivity
March 9, 2008 at 11:23 pm
I actually use dtSearch and have found it to be a very robust search tool. It is not an add on to the windows search or even built on it. My application is used to search documents in two areas. The end user is a franchise operation. There is a library that contains over 2400 docs of which about 1600 have expired but still need to be held for historical purposes. So i have the current docs in a blob in the database and the expired have been moved to a hard drive. The database size is well over 200Meg and expired docs is well over 3gig.
The second app uses the facilitator notes for each of the franchises. There are about 40 to 50 docs per year per franchise ... about 8000+ docs. Winforms app with SQL2005.
The explanation above is very accurate as far as Full Text Search definition. dtSearch is drastically faster than using the search in Windows plus the API is accessible to whatever your preference to languages as opposed to next to nothing from Windows or rather having to jump thru hoops to get to the Windows API.
SQL has some issues with some document types. dtSearch seems to be more accurate and comprehensive in the words included in the indexing.
I am not plugging dtSearch for you need to use the proper tool for the job and Full Text Searching from SQL may take care of your need.
Good luck
Brian
March 10, 2008 at 8:22 am
Good write up Brian. It is good to hear an accurate depiction of the product, from the other end of the table.
March 10, 2008 at 11:34 pm
Can u help me by furnishing the details regarding the products version of dtSearch.
March 11, 2008 at 12:08 am
The version number is 7.51 build 7556 as of the latest update.
March 19, 2008 at 5:55 am
Just to add few lines to Brians comments,
We have been using SQL Server FullText Indexing/Search, but recently switched to DtSearch.
As it is much faster, can take many rules for constructing search terms, can be very easily integrated with different components of your product(using different programming languages). Infact Dts is called a terabyte indexer, one catalog can be of terabytes of size and still search happens in lightening speed. One more advantage is, one can put the indexes over the network in any shared location and do indexing, so as to improve the overall performence of your SQLServer Database server, as indexing is a CPU intensive and long running operation.
I hope this gives some more insight to Dtsearch.
Though I am not trying to favour Dts, but just putting across few of it's benefits.
-Bibek
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply