Optimize DataTable

I'm using DataTable to render my tables. Home But now we have more than 1mi of data in the DB. Could someone help me with this? I'm trying to use the DataTable documentation but I'm not getting it. Actually I did, but I realized that in one of the fields, because it contains more texts, the query does not work. It is not a query error, because if I do it directly (without DataTable) it works. Thanks for the help ...