statistics calculation

[berny]

Hi there,

I need some help with this problem, please:

We have several tables with partially migrated (old) data and new data. Whenever a user navigates to a list of records (based on one table), there should be a display of statistics showing how many records are migrated, and how many are new ones. Also for search results. If I use statistic fields this slows down db performance very much - up to 50 users simultaniously, statistic function needs to run with every user accessing a list layout.

Is there any quicker way to do this (selfjoin relation, portals?)?

Thank you.