stored procs slower than 4GL?

Joe Lumbley writes: >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? Are their tables extremely dynamic? Perhaps the SPs are parsed and optimized for a different looking tables. Need to run UPDATE STATISTIC more often, which is an overhead in itself (a limitation in my book). Are they using too many SPs? In the class I took the instructor told a story about some developers who wrote their entire application in SPs. All that cashe'n of SPs slowed them way down. I think the benifits of SPs are overblown (here comes the flames). Their uses are limited. They do work well with triggers and with complex queries of static tables. They are not the 'Silver Bullet' of throughput. They are a resource that needs to be monitored. -- || ======= **** **T* ======= ||John Regep || **** **** ||Kmart Information Systems || **** *R** ||Kmart Corporation || =========== ********* =========== ||3100 West Big Beaver C-1 || ***A* **** ||Troy, MI 48084 || **** **** ||(810) 643-5078 ||=============== *M** **** ===============||uunet!kmart!jregep