CODEWITHSUNDEEP
jquerymysqljson
RyGuy
RyGuy

Reputation: 508

how to paginate a recordset

I'm pulling a recordset from MySQL, encoding as json and sending it back to a DIV on another page. I'm a little new to this data formatting so I'm wondering how do I go about using a pagination system? Do I paginate the MySQL results OR do I do it with json using jquery?

Upvotes: 0

Views: 314

Answers (2)

Garett
Garett

Reputation: 16828

I would paginate the data at the database tier. Depending on the size of the data you could end up with quite a bit of data on the client if you choose the other approach, which will affect performance.

Upvotes: 1

netdjw
netdjw

Reputation: 6007

Most pagination systems are based on unordered lists (ul), others based on table element. Maybe you get some useful information, and plugins here.

Upvotes: 0

Related Questions