Stored Procedures

> > How many people out there are using stored procedures to do any > significant amount of work? We are producing a Client Server version of > an existing 4gl product and response times are an issue. We are trying to > determine how much stored procedures can give us here. We would like to > push most of our code onto the server this way and only keep the > presentation logic on the client. Alternately we may find that only the > transactions and certain high use selects are suitable for this treatment > - which still leaves most of the code on the client. We were toying with > the idea of writing RPCs in 4gl (mostly anyway) but were hoping Stored > Procedures would give us what we needed with less effort. If any of you > have used them in anger I'd appreciate a response. There was an excellent article in a recent 'Database Programming and Design' which recaps the reasons for going with SPL. Performance of row processing is far superior to 4gl, especially in a client server world. I would say more, but I could not say it half as well. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, BSMC Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ Discover America, get lost on a rally. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________