450K rows of data need to fetch from sql server

Grafana MSSQL
,
1

Hello,
I’m using grafana 8.5.0, Here for table format pagination is available ,But i want to get part of data through API request on every page selection Because there is more than 450K rows of data in database.

Is that feature is available ?
Then how to configure it. Pls Help!

2

I don’t think that can be done. However nobody is going to read 450k rows. Maybe just fetch the first 2k rows? That’s already plenty to read…

1 Like
3

Hi @redshift1,

Thanks for the reply !

Actually, I want to get data through pagination wise doing API request for each page.

Is there any solution please suggest.