> Verity searches are very fast. The reason that it takes a lot of time
> must be that when you do a verity search with a Spectra-tag like
> "cfa_allTypeSearch" it executes the search and for every match it get
> it does a cfa_contentObjectGet to get the data for the object. This
> means that if you get 1000 answers from your verity-search it would
> then do 1000 sql-questions to the database and that takes some time.

I am using cfa_typesearch with resultSet="KEY" and an r_stResults. There
is not sql involved in there at all.

-- 
Michiel Boland <[EMAIL PROTECTED]>
Digital Valley Internet Professionals
Plantsoen 17, Wageningen, The Netherlands
Phone: +31 317 465555, Fax: +31 317 460276


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.

Reply via email to