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: Doug Fairclough <kensey at wired dot com>
Subject: RE: Executing stored procedures with parameters
Date: Mar 20 1996 6:11PM

> First off, I agree with Tom's statement that it's better to use the dbrpc*() 
> routines.  It'll take you a bit more time up-front for coding and testing, but 
> there's be no server time spent parsing/verifying the incoming SQL stream (such 
> as the "declare" and "exec" statements you started with). 

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.  

> In addition, invoking 
> your stored procedure via RPC cuts down on your network traffic to (and from?) 

i dont see how using RPC will impact network traffic.  the query is still 
going to bring back the same amount of data.

doug