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. Image for the cookie policy date

Performance issue when copying large amounts of data.

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?

2 Replies

AD Administrator Syncfusion Team June 27, 2005 12:26 PM UTC

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


KV Kristian Vinther June 27, 2005 01:29 PM UTC

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

Loader.
Up arrow icon