Follow SELECT with SELECT COUNT only when required.

cloudwan / gohan

Gohan is an API Gateway Server written by Go that makes it easy for developers to create and maintain REST-style API

http://www.slideshare.net/natiueno/gohan-61170476

Other

109 stars 44 forks source link

Follow SELECT with SELECT COUNT only when required. #733

Closed cierpuchaw closed 5 years ago

cierpuchaw commented 5 years ago

After every SELECT we called SELECT COUNT to return total number of entries in requested table. This can be different than number of entries returned from SELECT only if we use OFFSET or LIMIT from paginator.