Hi,

I have a general performance question based on some observed performance issues with my website. Recently, I added a series of chart pages using ARI DataTables modules. I added 6 pages, with each page using 2 dedicated ARI DataTables modules. Each module has a very long and complicated MySQL query pulling data from a database with over 2000 records. In total, these pages bring the total number of separate ARI DataTables modules in my site to 16.

After adding the 6 pages with the 12 new modules I noticed considerable performance issues with the site. It is very slow to load. To test whether the number of modules might be contributing I disabled 6 and noticed that the performance greatly improved, in particular loading performance.

Am I using too many modules? Does the DataTables module consume server resources? If so, is there any way I can improve performance of the modules? Can I possibly achieve the same result using less module instances?

My issue now is that I have an additional 3 more pages to create requiring I add 6 more modules, at 2 per page. I am using 2 per page because that was the only way I could get the module to create a table with both data and a totals row. The 2nd is to generate the total row. Here is an example of one of my pages.

sim-x.net/index.php/analysis/simulators-by-region

Please, I am open to any suggestions and options. I really like the ARI DataTables module and how it is implemented, but maybe I am pushing it beyond its capability. Thanks in advance.

Ken

Hello,

If try to load about 2k records by several module instances on the same page, it can work slowly on client side. In this case you can enable "Server side pagination" parameter (if data is loaded from a database and "ARI Data Table" widget is used) or show modules on different pages.

Regards,
ARI Soft

Sorry, but I may not have been clear. The returned data may get to 2000 only on rare instances. Plus, I only ever have a maximum of 2 module instances on any one page or article. There is a total of 16 on the site as a whole but spread over 10 pages. My question and concern is really more from the overall site loading perspective.

Ken

A performance issue can occur only if several modules instances are loaded on the same page and they load a lot of records or if "slow" SQL queries are used in modules (but this is not "ARI Data Tables" issue).

Regards,
ARI Soft

Based on your response, I have only 2 module instances on any one page, so I am not likely to see the ARI DataTables performance issue you describe.

If I have 16 total module instances on the entire website, are there any initialization issues or other delays I should worry about or watch out for? The slowness seems to be more of an initialization or http request issue.

Also, I understand that a slow SQL query might not be an ARI DataTables issue, but what would qualify as a slow query? If perhaps I have a slow query how would I know? If I do, I will need to improve, or remove completely, if they cannot be addressed in some other way.

Ken

Execute SQL queries in tool like PHPMyAdmin to see how long they are executed. You can also use EXPLAIN statement to see execution plan of an SQL query, it helps to optimize query.

Regards,
ARI Soft