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