Question
Enigma Metaverse
Enigma Metaverse
IN
Enigma Metaverse
Posted: Mar 13, 2024
Last activity: Mar 14, 2024
Last activity: 14 Mar 2024 7:32 EDT
Closed
Can anyone suggest Alternative approach to Pagination instead of RDB?
We need to respond to a service request that includes page and limit parameters. The response should contain a specific range of results based on these parameters:
- If page equals 1 and limit equals 10, only the first 10 results should be included in the response.
- If page equals 2 and limit equals 10, results 11 to 20 should be included in the response.
- If page equals 3 and limit equals 10, results 21 to 30 should be included in the response.
- and so on
Currently, we manage this by utilizing a relational database (RDB) with offset and limit functionality. Are there any alternative methods we could consider for achieving this?
***Edited by Moderator Marissa to add Capability tags***
To see attachments, please log in.
Posted: 1 year ago
Systems Limited
Systems Limited
AE
@thesriramguptha
Not Sure whether I get your requirement properly but I think We can Check the index of your source and then construct the response.
Param.Maxvalue will be = page * limit
Param.MinValue will be = (Param.Maxvalue -9)
Now suppose You have a source page from there you can check the index, if it falls within the Param.Maxvalue and Param.MinValue then You append those records in the response.