I'm looking for opinions on pagination using jquery datatables.
my thinking is that datatables are really bad for huge recordsets.
I believe one should page within the query itsself - not query for all records then just display a portion of those.
I'm looking for coherent reasons to use with my employer (who is trying to force me to use datatables)
for jquery people please provide reasons why it may be good
i'm hoping you guys know what I'm referring to - if not I can explain more.