|
Title: Virtual Scrolling DataGrid error occured when data rows exceed 750000 records. Post by: supun151515 on December 15, 2015, 07:48:38 AM Hi everyone,
I am testing Datagrid Virtual Scrolling with my database. DataGrid works fine with below 750000 records. But When I have records more than 750000, Grid will display only first 50 records(pageSize:50). You can see http://www.jeasyui.com/tutorial/datagrid/datagrid27.php (http://www.jeasyui.com/tutorial/datagrid/datagrid27.php) http://www.jeasyui.com/tutorial/datagrid/datagrid27_demo.html (http://www.jeasyui.com/tutorial/datagrid/datagrid27_demo.html) Just change above example with 750000 total rows. You can see how the grid will behave Quote $result = array(); $result['total'] = 750000; //before 8000 only $result['rows'] = $items; echo json_encode($result); Thank You, Supun Title: Re: Virtual Scrolling DataGrid error occured when data rows exceed 750000 records. Post by: stworthy on December 16, 2015, 12:36:20 AM Please refer to this example http://jsfiddle.net/ahbfaxd6/1/
Title: Re: Virtual Scrolling DataGrid error occured when data rows exceed 750000 records. Post by: supun151515 on December 16, 2015, 03:04:29 AM Thank you for your reply. All above grids are working fine with Google Chrome. Since I am using Firefox 41.0.1, above examples are giving only first 50 records(pageSize). Could you please try it with Firefox and let me know.
Thank You, Supun Title: Re: Virtual Scrolling DataGrid error occured when data rows exceed 750000 records. Post by: stworthy on December 16, 2015, 07:31:54 PM Please try to download the 'datagrid-scrollview.js' file from http://www.jeasyui.com/extension/datagridview.php
Title: Re: Virtual Scrolling DataGrid error occured when data rows exceed 750000 records. Post by: supun151515 on December 17, 2015, 03:37:53 AM Thank You,
It is working now. But as I noticed there are many changes in new datagrid-scrollview.js file. I suggest you to add version number on the top of every updated js file. It will be easy to identify new files without any conflict. Again Thank you for your immediate action on this issue. I have another issue and I will open a new topic for that. Hope you will help to solve it as well. Thank You, Supun |