Hi Johan,
On a Spectra project where we had to select on a combination of keywords and
properties we created a searchable keywords property that contained an
alphabetically sorted list of keywords. At search time if you take the
keywords you're searching for, sort them alphabetically and delimit them
with '%' you can do a LIKE search on the keyword property in the properties
table. On a type with about 2000 objects this was very quick. Could also
create an extra column in objects for this. Of course this probably won't
scale well - but to stretch the performance you can make sure that the like
is the last thing to execute, e.g (illustrative):
SELECT c1,c2,.. FROM (
SELECT c1,c2,... FROM ...
WHERE typeid='..' and ...
) WHERE keywords LIKE '%wordA%wordC%wordX%'
Another thought is full text indexing features in the database (e.g.
FREETEXT and CONTAINS in SQL Server).
Robin Hilliard
Senior Product Support Engineer - Asia Pacific
Macromedia, Inc.
> -----Original Message-----
> From: Johan Coens [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 17 January 2002 7:29 PM
> To: Spectra-Talk
> Subject: Alternative for verity search
>
>
> Hi all,
>
> Does anybody now a good alternative for the verity search used in
> Spectra. I
> wan't to re-implement the typesearch (and maybe the metadata)
> tags which are
> based on verity. Anybody done this before?
>
> Regards,
>
> =========
> Johan Coens
> <theFactor.e>
>
> Premium Partner for Macromedia
>
> "Imagination is more important than knowledge. Knowledge is limited.
> Imagination encircles the world."
> Albert Einstein
> =========
>
>
______________________________________________________________________
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.
