On Apr 13, 4:26 am, "pbd22" <dush...@gmail.comwrote:
My question: is there a performance cost by doing
all my paging server-side (and cost benefit by keeping
it on the client). Or, does it matter?
CMIIW.
I would recommend to do your pagination logic at server-side, then
javascript to do request paging (ajax + json recommended) and some
fashion.
The page size will be reduced, and the page loads faster (especially
in web page). The server performance will be increased too, because it
generates smaller page.
Few months ago, I got complain from user accessed around 250 rows on a
single page. More than 2 minutes until the page shown on P2 CPU. The
page is in an intranet application, and it use javascript to stripe
colors, fits each column width, etc, but no ajax.
Under development process, the data just about 30 rows and I didn't
think to do any pagination.
HTH