search

publicdevop2019 / docs

Apache License 2.0
10 stars 4 forks source link

Feature-Product: SpringDataJPA getProductByCategory extra query #20

Closed publicdevop2019 closed 4 years ago

publicdevop2019 commented 4 years ago

turn on hibernate debug to see, below is not used anywhere in response org.hibernate.engine.jdbc.spi.SqlStatementLogger: select count(productdet0_.id) as col_00 from productsimple productdet0 where productdet0.dtype='ProductDetail' and productdet0.category=?

publicdevop2019 commented 4 years ago

for pagination search, above is used for total element count

publicdevop2019 commented 4 years ago

custom pagination query to avoid this, but might be need later