I'm already doing something like this (only one method call not two) and
I'm already seeing performance hits... in my test cases I'm only returning
nine records, two of which are restricted.
cfa_contentobjectFind
cfa_contentobject method="AUTHORIZE" r_stparams=s
[normal cold fusion to process sorting and filtering]
This is what part of my tag stack looks like (I cut it off so I wouldn't be
too annoying) .... as you can tell I'm spending a LOT of time on the handler
calls.... I can'too imagine how long this page would take if my poor users
returned a couple of hundred results (In the grand scheme of thing, this
might be quite possible).
Execution Time
10950 milliseconds
Number of iterations:
cfa_contentobject: 9 cfa_contentobjectfind: 1 cfa_contentobjectget: 10
cfa_contentobjectgetmultiple: 1 cfa_contentobjectinvokemethod: 9
cfa_objecttypeget: 10 cfa_recordselect: 1 cfa_userisauthorized: 9
Tag tree:
cfa_recordselect / time: 76 ms
cfa_contentobjectget / time: 128 ms
cfa_contentobjectfind / time: 1382 ms
cfa_objecttypeget / time: 30 ms
cfa_contentobjectgetmultiple / time: 520 ms
cfa_contentobject / time: 1006 ms / vars: labels='cali test';
oids='00072D21-B770-1A9F-A11080D18122FE68';
cfa_contentobjectinvokemethod / time: 980 ms
cfa_objecttypeget / time: 376 ms
cfa_userisauthorized / time: 456 ms
cfa_contentobjectget / time: 10 ms
cfa_contentobject / time: 825 ms / vars: labels='def test';
oids='000866FB-0506-1A9F-A11080D18122FE68';
cfa_contentobjectinvokemethod / time: 798 ms
cfa_objecttypeget / time: 260 ms
cfa_userisauthorized / time: 250 ms
cfa_contentobjectget / time: 9 ms
cfa_contentobject / time: 798 ms / vars: labels='def test';
oids='000A3E58-06A2-1A9F-A11080D18122FE68';
cfa_contentobjectinvokemethod / time: 771 ms
cfa_objecttypeget / time: 285 ms
cfa_userisauthorized / time: 438 ms
cfa_contentobjectget / time: 28 ms
|-----Original Message-----
|From: Michiel Boland [mailto:[EMAIL PROTECTED]]
|Sent: Saturday, March 03, 2001 9:36 AM
|To: Spectra-Talk
|Subject: RE: Guidance? Cfa_contentobject and using the r_stParams
|attribut e...
|
|
|> Now that I've remembered the possibility of ordering the
|structures and then
|> passing the pure structures into the handler tag I realize I
|could give it a
|> try with a handler... but this doesn't really solve my
|problelm. What I
|> ultimately want is for cfa_contentobjectfind to only return
|objects that
|> aren't secured against the user. The way I'm doing it now
|I'm costing
|> myself execution time stripping out secured objects from the
|results set
|> with the use of the handler. NOT making me happy.
|
|Can't you do something like this:-
|
| cfa_contentobjectFind
| cfa_contentobject method="AUTHORIZE" r_stparams=s
| filter out objects for which user is not authorized
| sort resuling set of objects
| cfa_contentobject method="DISPLAYLIST" lobjectids="list"
|
|This should do what you desire with a minimum of tags involved. You can
|even cache the resultset in a session variable or something and have a
|ultrafast next/prev interface.
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
