Forum OpenACS Development: Response to acs-message,acs-mail status report.

Collapse
Posted by Dan Wickstrom on
There are two viable alternatives for porting connect-by statements, both of which are dicussed in this thread. So far we've only used the second option based on a variable length sortkey. The nested-set model which is also discussed in that thread works well, but insert/update performance will degrade as the table size grows.

Take a look what was done for acs_objects. You should be able to copy the triggers and modify them for your use in acs-messaging.