stored procs slower than 4GL?
Posted in 1995
One of our subsidiaries has some developers who are swearing that they are getting faster results using 4GL than they are with stored procedures. The stored procs are returning massive amounts of data with each fetch, but so is the 4GL. Does anyone know of any structural reasons or limitations that would cause the stored procs to be slower? From a theoretical standpoint, the stored procs are avoiding a lot of pipe traffic and parsing time. I can't see how equivalent 4GL (compiled) could be faster than the stored procs. Am I missing something? Joe -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) Dallas, Texas ----------------------------------------------------------------------------