[Lens] Table pagination

[flash1293]

The Lens data table uses virtualized scrolling to handle large tables. However in some cases it's easier to use pagination to step through your data.

This could be offered as an optional setting on chart level.

[elasticmachine]

Pinging @elastic/kibana-app (Team:KibanaApp)

[wylieconlon]

I agree that we should offer this, but let's also try to clarify in the language some of the common types of pagination that this does not do:

1. Pagination does not improve performance of queries, as all the data is loaded up front
2. The pages don't represent the "full data set", like if you had a SQL pagination
3. Pagination will affect how the chart is rendered to PDF/PNG reporting

[drewdaemon]

From convo with @flash1293: the current table page shouldn't survive a navigation event or a browser page refresh, however it must survive a dashboard data refresh.

[drewdaemon]

@flash1293 @ghudgins — also worth noting that the underlying component optionally supports user-facing page size configuration UI.

[flash1293]

@andrewctate good point - to me it seems like the Lens toolbar is a better place for this as it seems like we would anyway need a switch there to turn pagination on so its simpler to put the page size in there as well, but no strong opinion from my side how this setting is exposed.

[ghudgins]

if pagination is enabled it would be cool for this to then show up at the bottom of the table where it is in other places. mirrors the fact we don't put sort options in the lens toolbar

[drewdaemon]

It feels like we're moving toward a toggle switch in the toolbar. Either you want pagination or you don't. If you toggle pagination on, the page size options on the bottom left of the table show up.

What do ya'll think? (the text in the screenshot is just something I plopped in there) Do ya'll agree with my train of thought?