We have a client that used a custom tag to implement object-based security. When an object was created, it contained the UserID of the person creating the object (the "ATTR_CREATEDBY" property). When someone else tries to edit the object, the tage checks a LDAP server to see if that person belongs in the same group as the person who created the object. If so, the new person can edit the object. They would like instead to use Advanced Security and create a policy for each content object, giving edit rights to one particular group. After running a script to create a policy for each content object (which took more than a hour to run for roughly 1600 content objects), it appears the cfa_policyget tag takes 27 seconds execution time to return back the name of the one group that can edit the content object.
Is there any way to optimize this approach? Is there some way to optimize the tables in the smpolicy database (apply indexing of some type on specific tables)? Our configuration: Windows 2000 CF 5.0 Spectra 1.51 (with the Spectrasource update) SMPolicy database is stored in SQL Server 7.0 -Enayet Enayet Rasul Certified ColdFusion 5 Developer Certified Flash 5 Developer Fig Leaf Software Suite 500 1400 16th Street NW Washington, DC 20036 202.797.5418 (p) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. ------------------------------------------------------------------------------ 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.
