|
From: Samofatov, N. <Nic...@Br...> - 2004-04-11 07:49:14
|
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 |