Originally posted by kiranakula76
The normal assumption we made is stored procedures are faster than direct Sql statements passed from connection or command object.
I love it I am guessing you didn't benchmark that theory, eh?

I don't work with VB and the associated single-platform-closed-pseudo-technologies, but conceptually there should be no difference. You might tweak your client side fetch arraysize to improve performance, but you would have to profile where the slowdowns are in your code.