Big Issue on datatable using dynamic loading with paging

Webix JS
1

Hi.

I tried datatable using dynamic loading with paging and it worked well when the amount of data is small (<2,000). But when the amount increased to about 100,000 (>5,000 pages), it became extemely slow to finish loading one page of data (20 rows). The server response time was very short and the majority of response time was spent on the client side! I guess this was because the datatable component is designed to store and maintain the whole data no matter if I just wanted to view the first page! How can I solve this issue?

Thanks!

2

Hi,

Could you please provide a link to problematic page ? We have not reproduced the problem locally.

3

Hi, Maria.

Please try the link:
http://webix.com/snippet/0334e86e.

And you have to create a file as the data source for the url. The content of the file is quite simple:

    {"pos":0,"total_count":100000,"data":[]}

I found that the more columns, the longer response time. Just for your reference.

Thanks!

4

Hi,

Thank you for the demo.

The problem is caused by “adjust” property usage. If “adjust” is set, the library calculates the size of all cells in a column.

Obviously, there is a bug: there are no real records in your test demo and therefore, “adjust” should not affect performance. We will fix this problem in the next version.

However, DataTable in your application can contain up to 100,000 records and “adjust” will be applied to all loaded items to calculate column width.

So, please remove adjust: true from columns configuration and use fixed widths for the columns.

5

Hi, Maria.

It does work! Thanks for your help!