Performance issue when copying large amounts of data.

[Kristian Vinther]

Hi There.

Does anybody have some idea of the general performance of the GridDataBoundGrid, when you try to copy large amounts of data?

We have had some support issues with users thinking their client was "dead", when trying to copy 6000+ rows of data.

Is there any ways to tweak the speed of the copying process?

[Administrator]

Do not use the grid to copy the data. Instead, handle grid.Model.ClipboardCopy, and move the data directly from the datasource (ie, the DataTable) directly onto the clipboard.

If you try to use the grid to do this, it has to go through the indexer to get at each piece of data. This raises events and generally slows things down when you want to work with large amounts of data. But it is usually very efficient to loop directly through the datatable to get at the data, building a tab/newline delimited string using a StringBuilder.

Here is a forum thread that gives references to several copy/paste samples that show how to customize this behavior. I do not think any do exactly what you want, but they do show how to catch the events and use the clipboard.
http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=22163

[Kristian Vinther]

Thanks, I''ll try to look in to it.