ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: NearEarthObject on March 26, 2022, 01:27:22 am

Title: Sequential ajaxRequest with too many records
Post by: NearEarthObject on March 26, 2022, 01:27:22 am

Hi !

We have large records in database, so I follow the exemple here : https://paramquery.com/pro/demos/virtual_scroll
Thats works well and It increase the user experience by loading much faster a large amount of data.

I would like to know if there is a way to use pageModel with a type remote at the same time and how to do it ?

Title: Re: Sequential ajaxRequest with too many records
Post by: NearEarthObject on March 26, 2022, 04:08:38 pm

Also, I am not sur to understand what the var totalRecords nelongs too ?
Is theres a way to get a kind of sheme on php request side, applying a limit in mysql request limit($pq_rpp, $pq_rpp * $pq_curpage ) increase the response time, but completely paralysed filter.

The goal would be to divide the dataModel request in two, a first one who would initially charge the 100 first records, for a super fast result, and a nother one who would get all opther request silently in the background who would feed the dataModel with all other records.

I am not sure to be super clear.

Title: Re: Sequential ajaxRequest with too many records
Post by: NearEarthObject on March 27, 2022, 01:47:36 am

I solve my probleme !
I learn a lot  8)

Title: Re: Sequential ajaxRequest with too many records
Post by: paramvir on March 28, 2022, 07:24:06 pm

Sounds great!