It really depends on how your content is being displayed - if it's flat-file
then Verity is OK - if it's a combination of SQL and Verity then pass your
query through both database and verity, if it's all sql held then rely on
sql/verity collections (faster than plain sql requests), however database
searches will depend on how often the data is to be updated. A quick rule
we use for template based sites is verity index the flat file content, then
build a "link" database with file names and page titles in which is used to
display the url links to the content (your option 2).
However, saying the above the main downfall of Verity is that it takes a
f*** load of time to index large amount of pages and the collections can
become corrupt - so it may be worthwhile using something else completely
different (AltaVista supply a free search engine as do Lycos and Atomz).
What you have to remember is Verity with CF is a "lite" version and as such
is not too hot on larger sites.
As a rule of thumb "use the right tool for the job", don't just use a tool
because it is there.
J
"The Force is strong in this one..."
- Darth Vader
-----Original Message-----
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: 14 May 2001 17:45
To: CF-Talk
Subject: best search
what will be the best option for searching on text based content:
1. insert content into database, search using SQL statments
2. insert content into database, search using VERITY queried collections
3. VERITY search, collections will search directly on 1000s of txt files
4. Microsoft TextSearch Engine
5. SQL Full Text Search
Any help, please..
-Michael.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
