[Firebird-devel] Resource lists

[Samofatov, N. <Nic...@Br...>]

Hi, All!

Dumb replacement of resource linked lists with SortedArrays did ~15X
restore performance improvement and ~25X procedure compile timings
improvement as compared to CVS HEAD or B1_5_Release on esystem testcase.
Basically, its metadata (~350 tables, ~650 procedures, ~1100 triggers,
etc) restores in less than 30 seconds now. Memory consumption is still
horrible (>200 MB), of course.

In fact, my plan was the following:
1) Intoduce proper AccessItemList and ResourceList containers. This
cured bad timings problem.
2) Use references instead of cloning lists in post_trigger_access and
post_procedure_access. This should cure memory consumption problem.
3) Add caching of access masks for individual triggers and procedures.

I now finished stage 1 and may commit my code to HEAD if there is
interest.
Implementation of stage 2 may slow things down again, but not much I
hope. I'm willing to implement it next days.

Given the current timings I'm not sure that stage 3 will be necessary.

Nickolay Samofatov