Opened 6 years ago

Closed 6 years ago

#1973 closed enhancement (fixed)

Improve performance of project items list

Reported by: Nicklas Nordborg Owned by: everyone
Priority: major Milestone: BASE 3.6.3
Component: core Version:
Keywords: Cc:

Description

The Project->Items list can take a long time to load if the project contains a lot of items.

The reason is that behind the scenes BASE is loading all items in the project into memory, counting them, checking permissions, etc. I think it is possible to improve this by only loading the ID:s in the first step and then just load real items for the "few" that should be displayed in the list.

Change History (1)

comment:1 Changed 6 years ago by Nicklas Nordborg

Resolution: fixed
Status: newclosed

(In [7025]) Fixes #1973: Improve performance of project items list

If max number of items has been specified we only load IDs in the first step and use proxies to load the final items one by one only for the visible page.

Since this would impact performance for other code that wants to load all items in the project the old way of directly loading complete items exists (except that we now only load one item type at a time).

Note: See TracTickets for help on using tickets.