correction,
i kind of recollected this as my own problem of a client wanting 100k rows worth data downloadable.
we finally decided with csv dump and upload to object store, from where the client would download the file.
all other options like web ui with pagination etc were resulting in memory issues in the api.
so if it is how to render 1gb db worth data on a web browser, then ignore my answer.