IMHO, it would still be better to remove the Verity based metadata and add a
relational based design.
Tables would be
METADATA_metadata
metadataID
label
type [keyword|category]
parentID (self referencing to metadataid)
METADATA_link
linkID
metadataid
objectid (identifier of the object linked to a particular keyword or
category)
typeid (optional)
You get better performance, you don't get funny verity issues (apple and
apple sirop may both be found for the keyword apple), and you can actually
debug against a relational database.
We've built a toolbox around this concept and it seems to work great.
Haven't tested in Spectra though. I'd be interested if anybody sees this as
a good alternative. We may release it into the open source Spectra site.
Vriendelijke groet,
Marc Schipperheyn
<theFactor.e>
Premium Partner for Macromedia
The future is technological, but it will not be a world of gray steel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
