How can I limit and paginate results from a Grafana query when visualizing large time‑series datasets?

I am working with a Grafana dashboard that displays a time‑series metric containing millions of points. To keep the panel responsive I need to bound the underlying query so that only a subset of rows is returned, and I want to navigate through the full dataset using pagination controls within the panel.

The challenge is to apply a limit or offset (or equivalent mechanism) without causing excessive query latency, while ensuring that the pagination state is preserved across refreshes. I also need to understand how Grafana handles continuation tokens or page sizes when the data source does not natively support offset‑based queries. What query modifiers or panel settings achieve effective result limiting? How does Grafana manage pagination state when using limit/offset with high‑cardinality data? Are there performance trade‑offs between client‑side paging and server‑side limiting?