[CLOSED] Discussion: High performance with gridPanel
Hi!!!!
I wish high performance in loading data in gridPanel...
The performance in loading data in gridPanel, in this moment, is very satisfatory... But I wish target the top level scale.
Most part of my code is javascript.
The data access between gridPanel and database is with Json Webservice.
The WebService is returning a Extnet.Paging object serialized...
My database server is SQL Server 2k12.
I'm access data with sqlCommand and DataTable.
The data are returning paged... between 20 and 50 records each time.
I populate Extnet.paging with data returned in DataTable with a loop in datatable records. I think this is a critical step.
1- What is the best type of access data with high performance?
2 - There are any type of populate paging with a datareader instead of datatable? Without looping?
3 - Some article about performance in gridpanel?
Thanks a lot for any help.