Up Prev Next
From: leew at resport dot rch dot gs dot com (William Lee)
Subject: Re: Executing stored procedures with parameters
Date: Mar 20 1996 8:45PM
On Mar 20, 10:11am, Doug Fairclough wrote:
} Subject: RE: Executing stored procedures with parameters
} given how short the statements are, how long can this take ? i cant
} believe its going to be long enough to impact the overall execution
} of a query that is of any complexity.
} i dont see how using RPC will impact network traffic. the query is
} going to bring back the same amount of data.
}-- End of excerpt from Doug Fairclough
Use RPC call to exec Stored Procedure is faster, because the
parameter is passed as native datatype in contrast to dbcmd statement
which passes parameters as ASCII characters, it does not require either
client or server to convert between native datatypes and their ASCII
Especially when the SP take a lot input parameter.
Sybase Database Administrator
Investment Research Dept, Goldman Sachs, New York
1 (212) 902-8125 (desk)
1 (212) 902-3398 (fax)
1 (800) 509-0759 (pager)
1 (800) 800-7759 (alpha pager)