Hi @karthik 
Unless each record is so voluminous that you’re afraid it’ll take time to download the collection data in the browser, for a collection of a few hundreds of records, I’d recommend sticking with frontend pagination because waiting for your backend to return a result will take longer than.
Backend pagination usually starts making sense when you have thousands and thousands of records (sometimes less, sometimes more, depending on the volume of each record).
Here’s the section we wrote on the topic when recording level 2 of the WeWeb Academy.