Performance of "big" tables

sr22

Hey,

I have implemented datatables on my page. I have added a lot things like pdf export and child rows.
I now face the problem that my page is loading far too long. I now have about 600 entries and they seem to become much more.

My question is if the performance problem is caused by the data amount or by the implementation of the additional functions.

I display images in my table and they are also displayed in the pdf file.
The only solution I found for exporting images is to iterate over all columns with images and convert them to Base64.
May this cause my performance problem ?

I hope you understand my problem.

thanks, sr22

allan

The only solution I found for exporting images is to iterate over all columns with images and convert them to Base64.

Very likely. If you don't do that, is the performance better?

Allan

sr22

It's not perfect but it saves about one second or bit more.
Nevertheless it's not working very fast.

I now discovered that the workload of my cpu is increased enourmous when the page is loaded.

Is there a way to load for example only the half of the data on page load and load the rest in background ?

HPB

There is a section in the FAQ about how to speed things up.
I think in your case deferRender will help.

allan

Beyond the FAQ, can you link to the page so we can profile it and see what is taking so much time?

Allan

sr22

Hey there.

I found out that the page was fairly slow because ther was an application on my pc which needed so much cpu workload that there wasn't much left for javascript.

I removed this and it works a lot better now.

I thank you for your help!