I have a table with over 100,000 records. However by default when the user loads the datatable I would only want to return the last 500 records.
Is there some form of LIMIT query on the serverside that I can leverage?
I see you've marked this as solved. i assume you found the server-side processing mode?
It looks like you're new here. If you want to get involved, click one of these buttons!
DataTables designed and created by SpryMedia Ltd.
SpryMedia Ltd is registered in Scotland, company no. SC456502.