Click here to Skip to main content

Comments by jabit (Top 3 by date)

jabit at 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 at 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 at 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!

Advertise | Privacy | Mobile
Web03 | 2.8.141223.1 | Last Updated 1 Jan 1900
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid