Author Topic: Sequential ajaxRequest with too many records  (Read 582 times)

NearEarthObject

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 30
    • View Profile
Sequential ajaxRequest with too many records
« 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 ?

NearEarthObject

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 30
    • View Profile
Re: Sequential ajaxRequest with too many records
« Reply #1 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.

NearEarthObject

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 30
    • View Profile
Re: Sequential ajaxRequest with too many records
« Reply #2 on: March 27, 2022, 01:47:36 am »
I solve my probleme !
I learn a lot  8)

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6263
    • View Profile
Re: Sequential ajaxRequest with too many records
« Reply #3 on: March 28, 2022, 07:24:06 pm »
Sounds great!