Re: I need a good book or two on ADO
From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 09/25/04
- Next message: William \(Bill\) Vaughn: "Re: Reducing Number of Columns When Changing Query"
- Previous message: Dave_at_LAD: "Can't create hyperlink with ADOX"
- In reply to: Arnie Mauer: "Re: I need a good book or two on ADO"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 24 Sep 2004 18:46:33 -0700
This isn't surprising. The OLE DB providers are notoriously slow. I doubt if
the difference is in the language.
-- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ "Arnie Mauer" <xxx@nowhere.net> wrote in message news:O$%23cGbmoEHA.1588@TK2MSFTNGP09.phx.gbl... > "beginthreadex" <thomas_remkus@westwoodone.com> wrote in message > news:%23AmX2hYoEHA.1460@TK2MSFTNGP12.phx.gbl... >> There isn't one. ADO in straight C++ is fairly easy once you get it to >> work >> once. But that's always the case. I suggest that you look for a download >> package from Microsoft of samples in C++. Every method, every property >> are >> all outlined in there. Bill's book isn't going to help much except for >> some >> rules and basics. >> >> Once you get ADO to work, you'll want to look up ADO Record Binding. The >> only language you can pull this off in is C++ and it's faster than >> ADO.NET >> by multiple times over. Microsoft engineers don't even challenge this, >> but >> they sure don't make ads about it either. ADO.NET is supposed to do some >> sort of binding but it's not like C++ can do. It's pure bliss! But it's >> not >> something that you can do in a wink. >> > I have MSDN and so have the ADO reference and some C++ samples. However, > there seems to be a gap between the two. For example, the samples use > _ConnectionPtr but it's no where in the help. So I guessed at _FieldPtr, > but nooooooooooooo, it's FieldPtr :-( > > Performance. I created a test program that reads two numeric and one > varchar columns out of a table. No WHERE clause or anything. Just reads > about 1.25 million records. > > Using unmanaged C++, ADO and Oracle's OLEDB, it ran in 72 seconds. I > 'ported' it to C# and ADO.NET using the Oracle* managed DB classes and it > ran in 8.25 seconds. Go figure. > > - Arnie >
- Next message: William \(Bill\) Vaughn: "Re: Reducing Number of Columns When Changing Query"
- Previous message: Dave_at_LAD: "Can't create hyperlink with ADOX"
- In reply to: Arnie Mauer: "Re: I need a good book or two on ADO"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
