We have a large data set of 2200 records. Is it possible to use partial processing with pagination to limit the records brought back so that we don't have to wait 2 minutes for the screen to load the data?

Thanks for the quick response! I am looking at the example https://www.koolreport.com/examples/reports/datagrid/server_processing/. What are the packages that need to be installed for this to work like the example code?

Here is my code. I know the query works. This is the exact query.

use koolreport\core\Utility as Util;
use koolreport\datagrid\DataTables;

DataTables::create([
        'name' => 'Patient Utilization',
            "dataSource"=>function() {
                return $this->src('results')
                ->query("
                    select concat(p.lname,' ' , p.fname) as name,
                    (select count(*) from openemr_postcalendar_events as e where e.pc_pid = p.pid and e.pc_facility = 3 and e.pc_eventDate between $oneYearAgo and CURDATE()) as patient_appt
                    from patient_data as p
                    where p.financial_review_exp > '2019-07-01' and not testing=1
                ");
            },
            'scope' => $this->params,
            "options" => [
                "searching" => true,
                "paging" => true,
                "pageLength" => 10,
            ],
            "showFooter"=>true,
            "serverSide"=>true,
    ]);

According to my IDE, the Utility is not used. I appreciate the help.

No, we are not using a framework. Would it be better to use a framework like Symfony?

I dropped this code inside of OpenEMR. https://github.com/openemr/openemr Adding the "method" => 'post' made the system take longer than 5 minutes to produce a page and there were no error messages in the log.

Thanks for your swift responses.

Sebastian, XHR is not registering on the Network tab at all. I checked the error log also. No errors there.

Sebastian, No XHR for KoolReports is being executed.

I changed the 'name' to 'PatientUtilization'. It did not change anything. The system is not executing the ajax call to the database to get records. There are no error messages in the console and no errors logged in the PHP error log. Thanks for trying to assist.