Tables with more than 91,000 records

jpavan

Hi, Allan, it's me again.
This time, I try to show results in datatables that contains more than 91,000 records.
If I use datatables, I receive messages like:

If I use Editor:

(I'm using SQL SERVER 2008).

What solution could you recommend me?

Thanks!!!

allan

Two options:

1. Don't use server-side processing and accept that it will take time to download the JSON for the client to use (make sure you having paging enabled in the table and deferRender, or
2. Rewrite the server-side processing script to work with old versions of SQL Server. We only support server-side processing back to SQL Server 2012, as that is when OFFSET and LIMIT were added to it.

Allan