Forum OpenACS Development: Re: Faster cc_users in Oracle

Collapse
6: Re: Faster cc_users in Oracle (response to 1)
Posted by Dirk Gomez on 05/02/03 10:35 AM
PL/SQL in SQL is dangerous :)
Collapse
7: Re: Faster cc_users in Oracle (response to 6)
Posted by Brian Fenton on 05/15/03 04:32 PM
I notice this change definitely speeds up the view but for some reason I now get an ORA-01445 (cannot select ROWID from a join view without a key-preserved table) when banning a user.
Can anyone see why?