It's worth mentioning that there is some overhead for calling a stored
proc that isn't involved with straight queries, though it should be
minimal. Where stored procs REALLY shine is when you've got a query
whose result is only used for some logic driving another query. Using
a stored proc in tha
> Well, OK, not that dramatic, but every DBA I have ever known
> has told me that if you want performance, you use stored
> procedures. My quick test this evening has me rethinking that.
Just a warning - quick tests are often worth about the time you put into
them.
> The straight query using CF
2 matches
Mail list logo
