Re: stored procs slower than 4GL?

In article <jlumbleyD9IsJ1.5s@netcom.com> jlumbley@netcom.com "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? Have the stored procedures been updated recently? 4GL works out how to process each statement at runtime, so takes account of changes in table statistics. With stored procedures there is something (UPDATE DATABASE or similar) you have to do to get them to recalculate. Are the SQL statements in the stored procedures & 4GLs absolutely identical? Regards -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================