AllowMultiRowEdit = true. Can't perform Update Multiple Item if there is too many editing item at a time. Is it normal?

[LamKhoa]

I have set AllowMultiRowEdit = true in order to put every item in the grid to edit mode, then edit and update them all at once.
However, it seem to me that if there is too many item that are editing at a time, then the update won't work.
For example, if I set the PageSize = 80, it will work perfectly, but if I set it to be 100, then it won't work. At first, I thought that 80 is the limit number of row that can be editing at a time, but then when I tested with another grid, It works when I set PageSize to 50, but it won't work if I set the PageSize to 55.

I guess that it's has something to do with the limit of amount of data that the grid can hold at a time or so.

Would you please explain?

Thanks

Lamk.

 

[Angel Petrov]

Hi Lamk,

Generally RadGrid has no limitation of the items that can be updated. When using large number of columns and rows and you have a large database, multiple queries may cause poor performance. Please elaborate more on what are you trying to implement so we could give you some advices that may serve you well. However we do not recommend editing such large sets of data at the same time. You will get better performance if you use paging and if you edit smaller amounts of data. Additionally you could review this code library where an excel like grid is edited. I am also attaching a project for you to review in which I update a 100 rows at a time and it behaves correctly.

All the best,
Angel Petrov
the Telerik team

[LamKhoa]

That's right. I myself don't like the idea of Multiple Editing like this as it will likely jam my Database server.
But being a developer, it's not me who has the right to make all the decision, you know, we give user what they want, most of the time, it's their choice, not ours.

I can't open the project since I don't have the right version of SQL Server install.

Would you please increase the number of editing row from 100 to 500 to see?

Thanks

Lamk.

[Angel Petrov]

Hello LamKhoa,

I have modified the solution and retested. It took around 36-37 second to update 500 records.The time delay is due to the many SQL queries and cannot be avoided. Although you said you cannot open the project (it is a website, you can use the File -> Open -> Website in Visual Studio) I am attaching the modified solution in case you want to review it.

All the best,
Angel Petrov
the Telerik team

[LamKhoa]

I have SQL Server 2012 only, and it said that it can't open project with SQL Server 2005.
Would you please convert the database to SQL Server 2012?

Thanks

Lamk