Michiel, I'm not sure why it is so slow for you on 1.01. I can say, however,
that a simular test on 1.5 (actually, I'm running a newer version then the
released code) runs very fast. My test came back at 150ms.
If the SQL solution works well for you - I say use it. :)
=======================================================================
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
> -----Original Message-----
> From: Michiel Boland [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 10, 2001 6:40 PM
> To: Spectra-Talk
> Subject: cfa_objecttypegetmultiple
>
>
> Hi.
>
> I need to obtain a list of all typeIDs within a certain datasource. The
> cfa_objecttypegetmultiple tag is very slow. All I'm doing is
>
> <cfa_objectTypeGetMultiple
> dataSource=".."
> r_stTypes="s"
> >
> <cfset ltypes = StructKeyList(s)>
>
> This takes about 600ms.
>
> A sql query
>
> <cfquery name="q" datasource="...">
> select typeid from types
> </cfquery>
> <cfset ltypes = ValueList(q.typeid)>
>
> does the same job in about 30ms or less.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
