How to Cache Spring JPA Pagination Count Data?

Asked Dec 11 '19 at 23:22

Active Dec 14 '19 at 09:32

Viewed 980 times

I'm Creating a Simple Spring Boot application with JPA. I have millions of records to retrieve it from a database. in my repository when I call findAll(Pageable pageable) it gets the records I want.

But takes lot of time to return me the subset of records. I found it happening because of count query.

Is there a way we can cache the page response after first call ?

asked Dec 11 '19 at 23:22

user3470629

1

It's hard to believe that `count` query takes more time than `select` query. Probably issue is somewhere else – Nikolai Shevchenko Dec 12 '19 at 00:10
Count queries can affect performance. An alternative would possibly be to return a Slice. https://stackoverflow.com/questions/49918979/page-vs-slice-when-to-use-which – Alan Hay Dec 12 '19 at 08:47
but I also want count details for the first time, so ui will paginate it – user3470629 Dec 12 '19 at 17:25
**No one** will want to page through millions of records. – Alan Hay Dec 12 '19 at 19:00
right, but i need to provide pagination support, and get the total count once, and don't want to calculate for next page – user3470629 Dec 12 '19 at 22:46
Issue your query manually, cache the result and then use a Slice. – Alan Hay Dec 13 '19 at 11:21

How to Cache Spring JPA Pagination Count Data?

0 Answers0