How to Do Paginated Results

Mr. Hyper Magnetic out there asked to see what can we support paginated results. We'll pass it in results is one of those things that seems simple, but it's more of a quagmire than you might expect. The way we all did it years ago was we use these functions in called limit and offset. It doesn't have the server side, but still very slow. So nowadays, if you do pagination, you want to have some kind of approach where the query you're doing is looking at some data in the data.