-----Original Message----- On Wed, Apr 27, 2011 at 1:30 PM, Richard Kaye <[email protected]> wrote: > According to my text editor: > > The physical file on disk is 44,689,441 bytes. > It has 4,656,096 "words". > It has 1,772,884 lines. > The data structure in the XML has 6 elements per record; nothing very > complicated. > > I wonder how long it would take to parse that file and create an ADO > recordset? ------------------------
Depending on your disk quality and activity 3-10 seconds to read it. Putting all that content into a grid, double it. You say about a 1/4 mill rows? -- Stephen Russell [Richard Kaye] That's roughly what I got from the file in question. And I got to use one line of code to read the file and create the cursor. <vbg> (In Ed's honor, I decided to bottom post this particular reply despite having recently seen him top post for the first time ever...) _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD0441923ED5C7E@ACKBWDDQH1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
