• adnan
  • New member
  • Offline
  • Registered: 10/31/2014
  • Posts: 4

Topic: DB pager issue

Dear FA team,

First of all thanks for the great job to make FA a wonderful and handy ERP system.

I have a small doubt in using DB pager while making some Ajax calls. after the search completed and the results are displayed, I made some Ajax calls to get some extra data.

The problem is every time Ajax is called , the DB pager get called also and refresh the data.

In other words, DB pager connect to DB to run select SQL every time there is an Ajax call.

Is there a way to stop this. I mean if the SQL has not been changed and Ajax cal is made, then no need to connect to DB .

Treat this as a performance issue specially when the SQL to DB pager is complex and searches in huge table.


Thanks and Regards,
Adnan

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: DB pager issue

This is probably done to make sure that if any other user adds / deletes records in the meanwhile, it will reflect truly.

apmuthu's Website

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,182

Re: DB pager issue

you can create it, but you need to use jQuery datatable or some other table plugin.  Because the core supports to check each page due the change / update with other worker.

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • adnan
  • New member
  • Offline
  • Registered: 10/31/2014
  • Posts: 4

Re: DB pager issue

Thanks apmuthu and kvvaradha. Appreciate it.