Kay
You may want to consider the alternative of storing the content of
the html pages in the database and generate the "pages" dynamically
when requested.
Not all sites lend themselves to this, but for those that do, the
impact can be dramatic (especially in the creation and maintenance of
the content),
Once in the database, the content can be searched, formatted, cached
at will with simple CF SQL queries...
Any changes to the content is immediately reflected in the site (no
uploads, etc.).
This can easily outperform serving static pages.
I had one client with thousands of static html pages... now there is
an SQL database & 75 CF templates.
HTH
Dick
At 3:59 PM +0800 1/3/01, Kay Smoljak wrote:
>Hi all,
>
>I have an application hosted on CFAS 4.0.1/MS SQL Server 7 which requires a
>search feature for news articles. The article text for each item is stored
>in an external html file. The title, category, date and filename for each
>article is stored in the db. I am kinda stumped as to how I can elegantly
>search the full text of the articles. Could this be a job for Verity? I have
>not used it before. And if it is, how can I associate the correct db entry
>with the text in the external file in my search results?
>
>Thanks for any pointers,
>K.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
