[thelist] ASP vs TSQL

[Michiel Trimpe]

Hello Oren,

OL> Really?

Yes, it's not the procedure that costs time it's the connection time.
Stored procedures are compiled and stored in the database and are
therefor at least as fast as ASP and you'll always need only one
connection, which is the time-consuming bit.

OL> The only way to know for sure is to code both and benchmark.

That's the only way to find out. I'm a MySQL man so I can't do it
myself but I'd like to hear the results.

-- michiel

OL> -----Original Message-----
>> ... perhaps I would be better off just passing the array through
>> to a stored procedure and allowing it to loop through it.
>> Resulting in one call to the database, rather then repeated ones.
>> Would this be a good idea?

OL> hi norman

OL> yes
OL> evidence, while anecdotal, suggests significant savings
OL> makes for cleaner code, too

OL> rudy




--
Best regards,
 Michiel                            mailto:M.B.Trimpe at student.tue.nl