PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

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
time
} of a query that is of any complexity.
}
......
} i dont see how using RPC will impact network traffic.  the query is
still
} going to bring back the same amount of data.
}
} doug
}-- 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
equivalents.
Especially when the SP take a lot input parameter.


-- 
William  Lee
Sybase Database Administrator
Investment Research Dept, Goldman Sachs, New York
leew@rch.gs.com
1 (212) 902-8125 (desk)
1 (212) 902-3398 (fax)
1 (800) 509-0759 (pager)	
1 (800) 800-7759 (alpha pager)