> I have to say one thing about this however. Even after upsizing the
> SMPolicyStore and the UserDirectory, applying this security is VERY
> slow. It is taking at least three minutes to apply security to five
> method for three groups, and this is on a very fast dual processor Dell
> and a separate very fast dual process Dell running SQL 7. We still have
> this as an issue and are trying to resolve this with Allaire. If after
> you see how we are doing it, you can come up with improvements those too
> would be VERY helpful to us.
>
> Anyone else seen this problem?
I have and it drives me insane. ColdFusion does extremely silly things
when it comes to Advanced Security. I don't know if it's a bug in CF or
the underlying Siteminder engine, but if you have an ODBC policy store
with 10000 policies (not a particularly large one, mind,) you get 10000
select statements if you create a new policy. Let's assume you have an
extremely fast SQL server that can prepare and execute 1000 select
statements per second; then it still takes 10 seconds to update a policy
store with 10000 policies!
Advanced Security in its present implementation is just unusable. Perhaps
it might work with an LDAP policy store but I haven't tried it.
--
Michiel Boland <[EMAIL PROTECTED]>
Digital Valley Internet Professionals
Plantsoen 17, Wageningen, The Netherlands
Phone: +31 317 465555, Fax: +31 317 460276
------------------------------------------------------------------------------
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.
