Access to Memory (AtoM)

Initial test show a signficant performance increase when testing treeview performance for a large fonds (122,191 descriptions).

Default AtoM database indexes:

- SQL query: ~ 70 s
- Data formatting: ~ 3 s
- JS request/load: ~ 5 s

The developer added the following index on the 'lft' column in the information_object table:

CREATE INDEX lft ON information_object(lft) USING BTREE;

Which dramatically improved query times (test repeated four times):

SQL query:     1.64  1.59  1.65  1.50 s
Request time:  4.85  4.87  4.92  5.09 s
JS work:       8.28  8.25  8.35  8.52 s