[Aplaws-devel] [aplaws - Developing on APLAWS+] RE: Performance

[Aplaws D. L. <apl...@li...>]

Read and respond to this message at: 
https://sourceforge.net/forum/message.php?msg_id=4404523
By: pboy

Chris,

just a question: I suppose your patch r 1586 (SF 1707913) in trunk is for the
described changes?

If it is:

|  I have only made changes to Oracle versions of the triggers - I am not sure
about writing triggers
|  in postgres sql. Without these changes there are only minor benefits for
pg users - the change to
|  PermissionManager speeds things up a litle bit.

We are quite interested in performance issues for postgresql and it would be
fine to benefit from your findings, too. As I understand, it is just a matter
of writing the trigger? No other modifications required for postgresql? May
be we could write the triggers. Do you have a test scenario at hand to ensure
the patch will work correctly?

And what about:

| delete all existing entries from dnm_object_1_granted_context where the associated
object_context
| entry has null context and there are no entries in acs_permissions (that's
145000 out of 173000 entries
| on my test instance!!)

is deletion part of the upgrade script of just your experimental procedure?



Peter




______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit: 
https://sourceforge.net/forum/unmonitor.php?forum_id=368401