Performance

[Eugenious]

Can anybody honestly tell me that if use a basic SQl Select statement form VB6 (exp: "Select * From Update")
as oppossed to calling a stored procedure in SQL, that one way has better performance than the other. I understand that stored procedures are great for larger processes but when it's this simple isn't a stored procedure overkill? Any insight on this is greatly appreciated!!!!!!!!!! GENE

[DerFarm]

I have maintained for a long time that the question of speed is
more a "religious" issue than otherwise. Unless I get a speed
increase of > 2 (twice as fast), I'm coding whatever is easiest to
understand 6 months from now.

The difference between 30 secs and 1.5 min to completion just
isn't that important in most applications.