Geek asks and answers

How to add pagination in REST API?

I make my own twitter. I exposed the corpus twitter request as a REST API using Java Servlets. However, when I perform a search using the REST API, all results (> 1000) are returned in a single HTTP response, and it takes some time to load.

I plan to add pagination for search, for example, the Twitter API. For instance,

http://search.twitter.com/search.json?q=blue%20angels&page=1&rpp=50

http://search.twitter.com/search.json?q=blue%20angels&page=2&rpp=50

Here rpp are the results on the page. Thus, in query 1, you can get the first 50 results by requesting a selection on the next page with 50 results.

Any suggestions on how this can be done in Java servlets? Now it’s very slow, as the HTTP response is getting huge ..

+3
source share
1 answer

Obviously, create the page and rpp parameters and get them in your servlet.

Then you need to use these values ​​to efficiently query the underlying database. The syntax for pagination syntax may differ from DB to DB.

For MySQL, for instace, efficient paging is done here .

0
source

More articles:


All Articles