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.