Elongated response times observed in development server
The development server experiences extremely poor response times (minutes to try to open rules, save rules, and other such actions).
Steps to Reproduce
Open, save and checkin the rule to observe the issue.
The slowness is a result of poor usage of indexes for table pr_sys_appcache_shortcut by Oracle. This is a known issue with Oracle when index uniqueness goes beyond 32 characters.
Below is a link to a PDN article describing the root of the problem where Oracle ignores the index due to its apparent non-uniqueness.
0% found this useful