Forum OpenACS Development: Re: Compatibility Matrix
From our experience getting rid of the huge materialized tree tables (having many duplicate keys), and move towards recursive queries looks much more promising. As effect, e.g. permission queries are now several times faster with 9.0 then they were with 8.3 (we are using the recursive queries in production since summer). However, this path requires some data model changes. Victor has the packaging of the changes in a more or less non-destructive way mostly done, just a matter of days. The package will be made available to the brave (i.e. early adapters). Depending on the results we can decide via TIP, whether that should go into the main branches.