ado.net data access performance

  • Thread starter Thread starter John
  • Start date Start date
Huh ? Bill did you made a typo :-|

Shouldn`t this be
I recommend doing
this processing on the sever using TSQL if possible or CLR procedures if
not. THIS is invariably faster.
Click to expand...

Or am i completely missing something ? :-(


Michel
 
Yes, of course. My migraine is getting to me.
Thanks

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
 
Michel,

Yes but what you write the case here

I used the datareader in past to get small amounts of which exist is more
than two pieces. Now I use more and more the executescalar and connect the
two pieces to a string with an # as seperator and split them after
receiving.

Ever tried? In my idea it is very effective.

(I don't have batch processing here, in that case I would have used the
datareader, by instance when I had to process a bunch of invoices for a
energie company).

Cor
 
Back
Top