Forum OpenACS Development: Re: weird problem with bugtracker / workflow

Collapse
Posted by Dirk Gomez on
Those in lists were a BIG misdecision by OpenForce (it seems they were the ones who started using them).

We should remove them step after step. They lead to contention issues in Oracle due to overly frequent reparsing...essentially we could move back to using string concatenation instead of bind variables.

This bug will sooner or later surface in other packages on the AIESEC site and on every other site if we don't tackle it.

IN subqueries or temporary tables (are they available in PG?) could be a solution. Not an easy task though🤔