Hello Himanshu

Sorry for the late response.

I'm not sure if this can be done, so I forwarded your question to one of our developers. As soon as I hear from him, I will let you know.

Sorry for the delay once again.

Hello again Himanshu

Unfortunately, with the built-in functions this can't be done. This has been requested a few times already, so let's try this:

Go to file wp-content/plugins/wpdatatables/templates/wpdatachart.inc.php and on line 6 you will find this:

<div id="wpDataChart_<?php echo $chart_id?>" class="<?php echo $this->_type?>" style="width: 100%"></div>

Below that, add this: 

<div id="wpDataChart_<?php echo $chart_id?>_preloader" class="<?php echo $this->_type?>" style="width: auto; height: <?php echo $this->_height ?>px; margin: 0 auto; background: url(<?php echo WDT_ROOT_URL .'assets/img/spinner.gif' ?>) no-repeat center center"></div>

Then, in file wp-content/plugins/wpdatatables/assets/js/wpdatatables/wdt.highcharts.js on line 156 you will find this:

render: function(){

Below that, add this:

this.options.chart.events = { load: function () { document.getElementById(obj.getContainer().replace('#','') + '_preloader').style.display = 'none'; } }

You'll have a default loader before the chart is loaded. This is only for HighCharts, though, so if you need this for some other engine, please note that this is a custom solution, and is not included in the provided support for the plugin.

When you test this, please let us know if it works fine, and we'll see that it's added in our next release.

I'm not sure what's going on Himanshu.

Regardless of the changes you've made you smile be able to save the file.

You can extract wpdatatables.zip finder; edit the files locally; zip it again and reinstall the plugin. That will cause it to load the modified files.

Just make sure to leave "Prevent deleting database tables" check box selected in wpDataTables settings, so you don't lose your tables and charts.

Thanks, Himanshu

I forwarded the question to our developer again, and as soon as I hear from him I will let you know.

Sorry for the delay.

Hi again Himanshu

Our developer thinks that it could be the server. Can you try optimizing your queries? If they're complicated, you could please prepare a MySQL view, which will return the data that you need, call it e.g. “view1” and then build a wpDataTable based on a simple query like “SELECT * FROM view1″.

Also, you can try some other hosting with better performances. Our developer said that this is not caused by wpDataTables.

You're welcome Himanshu.

If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.