Loads datable after 120 sec.

shrogers

Hello,

I have an issue and any assistance given would be appreciated.

I have a query that pulls data from an MSSQL database and loads it into datatable base on criteria in a dropdown. I'm using "ssp.class.php"
echo json_encode(
SSP::simple( $_POST, $sql_details, $table, $primaryKey, $columns )

When I select specific criteria ("467790") from the dropdown, the table loads in over 120 seconds and timeout sometimes. Any other value loads in 3 seconds bringing back over 26,000 records.

As part of my validation to isolate the issue, I tried commenting out variables in the array. With the below 4 enable, results (28,000) comes back in 3 seconds. As long as I enable more than 4, results come back in 120 seconds or timeout.

$columns = array(

array( 'db' => 'CIFPan', 'dt' => 0 ),
array( 'db' => 'CIFCardStat',  'dt' => 1 ),
    //array( 'db' => 'CIFAcctNum1',   'dt' => 2 ),
    //array( 'db' => 'CIFFName',     'dt' => 3 ),
    //array( 'db' => 'CIFLName', 'dt' => 4 ),
    //array( 'db' => 'CIFExpDate',  'dt' => 5 ),
    //array( 'db' => 'CIFUpdateDate',   'dt' => 6 ),
    //array( 'db' => 'Branch',  'dt' => 7 ),
array( 'db' => 'CIFUserId',  'dt' => 8 ),
array( 'db' => 'RecordId',  'dt' => 9 ),

);

colin

This section of the FAQ should help, it discusses various techniques to improve performance,

Cheers,

Colin