>> 2. Am I allowed to use cfa_typesearch against an alltype collection?
>Are you allowed? Sure. In fact, that's the ONLY way to search that
>collection.
If I am correct, this statement should be No. Only the cfa_allTypeSearch can
be used for to search the alltype collection. Well that and a direct
<cfsearch>. The <cfa_typeSearch> is used to search the property collections
of the TYPE.
As for if you should have separate object indexes, this will depend upon how
you do your searching. If you just searching individual types or just a few
at a time (<cfa_typesearch> allows you to pass in multiple type ids), then
separate object indexes would be all that you need. If you are looking to do
a full content search then the ALL type index would be a good fit. Also,
nothing stops you for having both.
Ben Elmore
Macromedia Spectra Product Evangelist
-----Original Message-----
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 8:35 AM
To: Spectra-Talk
Subject: RE: Searching on Verity Collections
> My Spectra app has a Verity collection sitting in the right place with the
> name cfa_alltypes_myapplicationname. This was created by me doing a
> cfa_typeindexall on the app.
> I don't have separate individual object indexes.
>
> When I try to do a cfa_typesearch the search dies, telling me the
> collection
> name isn't found. cfa_alltypesearch passing all the appropriate
> attributes
> including a single type, and a restricted list of properties takes
> absolutely ages and maxes out the CPU on the dev box I'm using (granted,
> less than ideal hardware). Return of results takes bloody forever or just
> hangs.
>
> What I'd like to know is:
>
> 1. SHOULD I have separate object indexes?
It depends. First, you are making a mistake with your code. If you use the
'All' collection, you MUST use cfa_alltypesearch. CFA_TypeSearch is for
individual collections.
> 2. Am I allowed to use cfa_typesearch against an alltype collection?
Are you allowed? Sure. In fact, that's the ONLY way to search that
collection.
> 3. Why is it taking so bloody long, there are only about 5000 objects of
> the type I need to know about in the CODB.
Have you optimized your collections recently?
=======================================================================
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
Email : [EMAIL PROTECTED]
ICQ UIN : 3679482
"My ally is the Force, and a powerful ally it is." - Yoda
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
