Ray
Thanks. Minor, but fundamental misunderstanding on my part...
<slaphead>Whack!</slaphead>
Steve
========================================================
Stephen Collins, Technical Consultant - ACIS (Australia)
Email : [EMAIL PROTECTED] ICQ UIN : 56321783
"Before I got into triathlon, I was a normal person."
> -----Original Message-----
> From: Raymond Camden [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 12 June 2001 10:35 PM
> 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.
