We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

What is maximum record ej grid can handle

Thread ID:

Created:

Updated:

Platform:

Replies:

120722 Oct 8,2015 11:41 AM UTC Oct 9,2015 03:34 PM UTC JavaScript 1
loading
Tags: ejGrid
Bharat Buddhadev
Asked On October 8, 2015 11:41 AM UTC

I am using synchfusion grid with angular js 

can i know what is maximum number of row allow in grid with better performance

If I want to test with  6000 records will synchfusion performance will allow me ?


Ragavee U S [Syncfusion]
Replied On October 9, 2015 03:34 PM UTC

Hi Bharat
 
We analyzed your requirement, and we have created a sample in Essential Studio Javascript with 6,000 rows and 5 columns.
 
Please refer to the table for performance of Grid in various browsers.
 
Action
Time in Milliseconds (Firefox)
Time in Milliseconds (Chrome browser)
Time in Milliseconds (IE11)
Initial Load with normal scrolling
~3395
~3489
~20662
Initial load with virtual scrolling
~81
~81
~226
 
The grid performance largely depends on the number of cells being rendered. So the performance is proportional to both the number of columns and number of rows. The maximum number of records the grid can handle with better performance is 15,000 rows and 5 columns.
 
Action
Time in Milliseconds (Firefox)
Time in Milliseconds (Chrome browser)
Time in Milliseconds (IE11)
Initial Load with normal scrolling
~8422
~6552
~53851
 
We can use “Virtual Scrolling” Grid feature to increase the performance of the grid upon binding large data to grid. With Virtual Scrolling enabled, only the data corresponding to the requested page will be loaded i.e., load on demand. So the grid load performance will be enhanced. Please find the online sample link for Virtual scrolling below.

http://js.syncfusion.com/demos/web/#!/azure/grid/paging/virtualpaging 

But we have provided only limited support to Virtual Scrolling. The following list of Grid feature will not work when Virtual Scrolling enabled.
· Editing
· Frozen rows and columns
· Cell Merging
· Responsive Grid
· Grouping
· Detail Template and Hierarchy Grid

We have already added it to our feature request list. So if you are in need to use those above listed features then we suggest you to use Pager in Grid control that supports “on-demand paging”.
 
For your convenience, we have attached the sample and it can be downloaded from the following location:
 
Sample Link: http://www.syncfusion.com/downloads/support/forum/120722/ze/AngularJS_Sample1388821958
 
Regards,
Ragavee U S.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;