FrontAccounting forum — DB pager issue

Re: DB pager issue

null@example.com (adnan) — Wed, 05 Nov 2014 05:12:47 +0000

Thanks apmuthu and kvvaradha. Appreciate it.

Re: DB pager issue

null@example.com (kvvaradha) — Mon, 03 Nov 2014 05:11:18 +0000

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.

Re: DB pager issue

null@example.com (apmuthu) — Sat, 01 Nov 2014 17:03:41 +0000

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

DB pager issue

null@example.com (adnan) — Fri, 31 Oct 2014 11:51:20 +0000

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