Large Table Count

[13ran]

Would it be possible to add a way to turn off the count query or provide my own count? I have a table with millions of rows and it causes very slow execution/ timeouts

[n1crack]

Yes it is possible. When setting setTotalRecords, it doesnt run the count statement for the full query.

    $path = dirname(__DIR__).'/database/Chinook_Sqlite_AutoIncrementPKs.sqlite';

    $dt = new Ozdemir\Datatables\Datatables(new Ozdemir\Datatables\DB\SQLite($path));
    $dt->query('Select TrackId, Name, UnitPrice from Track');

    $dt->setTotalRecords(3503);
    return $dt->generate();

[13ran]

Thank you!