[EuiInMemoryTable] A way to maintain pageIndex after the data updates

[igoristic]

Our monitoring tables update data every 10s, meaning the rows/data are still the same but some stats/column-values like: memory, cpu, etc changes. The problem is when we go to any other page than 0 and update states the table always reverts to page 0, guessing because of this line here: https://github.com/elastic/eui/pull/1798/files#diff-10dd11a4410be7cac57994d3b55fc179R162

The only way I can fix elastic/kibana#32663 is by un-mounting and remounting the component every 10s, which is not very performant and can flicker on some browsers.

Something to keep in mind if/when implementing: getDerivedStateFromProps is also triggered with table search, so we do still want to keep the current/default behavior of reverting to page 0 when searching

Relates to elastic/kibana#32663

[walterra]

We hit this issue on the Kibana Management page for the transforms list too:

In the GIF you can see that the list resets to page 1 (index 0) when hitting the refresh button.

[github-actions]

👋 Hey there. This issue hasn't had any activity for 180 days. We'll automatically close it if that trend continues for another week. If you feel this issue is still valid and needs attention please let us know with a comment.

[github-actions]

❌ We're automatically closing this issue due to lack of activity. Please comment if you feel this was done in error.