|
Title: Poor performance with large row or column count Post by: pacific202 on November 28, 2011, 12:11:32 PM I'm getting excessive load times and unresponsive script errors when I try to load a datagrid with 22 columns (plus one checkbox) and 272 rows. My grids won't ever get much larger than this so I am at the upper bound of size requirements.
Is there anything I can do to improve speed and stability? Title: Re: Poor performance with large row or column count Post by: stworthy on November 28, 2011, 06:19:51 PM Paging is the easiest way to manage large rows within the datagrid. Set 'pagination' property to true to allow datagrid paging.
Title: Re: Poor performance with large row or column count Post by: pacific202 on November 28, 2011, 07:52:57 PM Thanks for the quick reply.
I did set pagination=true as an experiment this morning, it picked up the correct number of pages but still displayed all 270+ rows. Is there something else I need to do to make that work? Title: Re: Poor performance with large row or column count Post by: stworthy on November 28, 2011, 08:04:27 PM Please refer to this tutorial http://www.jeasyui.com/tutorial/datagrid/datagrid2.php.
In your server, you will get 'page' and 'rows' request parameters. You should return exactly 'rows' records to browser not all records. Title: Re: Poor performance with large row or column count Post by: pacific202 on November 28, 2011, 09:04:44 PM Unfortunately that's not an option for me - the server API is restricted.
I have limited the grid to four columns and it is now loading quickly. I can work around this. |