Any way to optimize sp_sproc_columns - 08-11-2003 , 10:38 AM
We just upgraded from SQL 6.5 to SQL 2000. We also have moved SQL Server to
a much beefier machine. Actual data access in our database is much faster,
but we've noticed that the speed of the application itself has slowed down
some because sp_sproc_columns now seems to take quite a bit longer to run
than it did in 6.5. It's really apparent in portions of our app where we
issue several consecutive calls to the DB in rapid succession. We're using
RDO to access the database, and right now changing that is not a viable
option. Does anyone have any ideas how to either tweak sp_sproc_columns, or
replace it with something more efficient?
Thanks in advance,
Re: Any way to optimize sp_sproc_columns - 08-11-2003 , 10:51 AM
Maybe you could adapt something like this?
"Brett" <do.not.spam.me.you.jerks.maelstrom1335.NO.s.p.a.m (AT) swbell (DOT) net> wrote
in message news:Om6k29BYDHA.1748 (AT) TK2MSFTNGP12 (DOT) phx.gbl...