Comments by jabit - CodeProject

jabit 15-Sep-10 19:59pm View

Yes, the point wasn't to avoid the loop, just to avoid the set_Item call for every iteration of the loop. DataRow.set_Item takes an average of 30ms whereas setting it in xml takes only nanoseconds.

jabit 15-Sep-10 18:19pm View

NOT true, I solved it, finally! I serialized the data into XDocument's in memory and performed the swaps using XElement.Add() to set the missing cell values. There's a tiny bit of extra overhead converting the DataTable to XML and then back but overall my code is now nearly 30% faster!

jabit 9-Sep-10 12:52pm View

I will change my question, I was hoping I could do some kind of join in code or just replace an entire datacolumn but it looks like you're right, looping is needed. However I want to do it without calling DataRow.set_Item for every item since that is where the time is taken. Microsoft doesn't support and recommends against accessing the SharePoint database directly, only through the API.

Something I'm playing around with now is serializing the sharepoint data into XML in memory, performing all of the swaps against XmlNode's and then deserializing it back into a table, so far it looks promising!

Comments by jabit (Top 3 by date)