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.
We use CF451SP2 and Spectra 1.0.1 (and no we cannot/don't want to upgrade
right now thank you very much :)
Any reason why cfa_objecttypegetmultiple is so slow? (Well, I guess I
could look at the code but it's past midnight over here.)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
