Sure - for v. big sites I have used AltaVista (www.dfee.gov.uk for example)
and this is coolio - if I was to do it again though I would probably use
Atomz.com stuff - for various reasons.
Rationale for splitting full address into 3 parts:
1) Holding one url field means that you may as well use the default verity
url param - but this does not allow for the inclusion of template page build
variables.
2) Split the url into file name and variable includes means that if you have
variable includes on a template you can include them (e.g. you have
everything in you site coming through index.cfm with a menu variable and a
content variable) - so index.cfm would default to the base menu and content,
while links from this page would include alternate menus and content - e.g.
index.cfm?menu=search&content=sitemap would use the base template, pull in
the "search" menu (with relative sub-section options) and the sitemap
content (check out www.connexionscard.gov.uk for an example of this)
3) there are some cases however when you may need a pre-variable (such as
the javascript example I gave earlier - hence the 3 way split....
We are familiar with MSSQL Full Text Search, but it did not rock our
world....
Key, custom1, etc is fine, but the pages/text content do not hold the
relative include variables we need when building a nested template site (see
above break-down).
sorry I can't be of more help though....
J
-----Original Message-----
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: 15 May 2001 11:59
To: CF-Talk
Subject: Re: best search
My problem is that I'm already have 300mb of textual content.
The Verity Connection to CF really rocks and can help significantly in
design,
but I don't think it can handle the amount of data. Are you familier with
Microsoft
Solutions for this? (i.e MSSQL Full Text Search?)
As for your project, I don't see no reason why should you even connect to
SQL
every time to get the unique ID or anything else, why don't you use the
KEY,CUSTOM1
and CUSTOM2 fields to better process (with minmial milliseconds costs and
risk that the SQL would
be down...)
also, I don't see the real use in spliting the full address into 3 parts
(can you please exaplain
and give an example on why this is of use?)
I use verity on another site (http://www.imvamp.com) without no need to go
to the database.
ofcourse, the data was exported to sql, but only to be arranged more
efficiently into a Verity
collection. In your case of 40mb, I would consider doing the same.
Any help on MS SQL Full Text Search would be great!!!
Thanks,
Michael Lugassy
IT/WEB Specialist
Interactive Music Ltd.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
