Re: Overhead of Stored Procedures

Dave Pavlich (dpavlich@neo.lrun.com) wrote: : I am considering moving some of my Client Server processing to Stored : Procedures that would run on my database server. I'm concered about : introducing overhead and extra processing to my server. The majority : of my transactions are non-complex selects. that is the whole point of stored procedures, is that they move some of the processing to the engine, where it can be done more efficiently than on the application side, hopefully involving less data being sent across the net, which is ususally the bottleneck of a system. that doesn't mean that everything should be run as a stored procedure either. sp's are not for casual programming, they are really to be used for tasks that are usaully pretty basic, atomic in nature, and are executed many times, usually by many users. there is a really whorthile book through the the informix press and prentice hall, although the title and author escape me. it can be found on any of the online book sites. i recommend it highly if you are going to do any sp programming. hope that helps. mickm -- _____________________________________________________________________________ Mickey Mestel mickm@netcom.com -on a beach in thailand to a beautiful, stoned, norwegian woman: "..yeah, it's just another foreign country without ice." -----------------------------------------------------------------------------