MrBottomFeeder
12-17-01, 14:12
| I am having a problem with stored procedure performance. I am creating a package that has 42 procedures. The package has a main procedure which calls the other 41. A global temp table is being used to build up the result. The call to the second procedure hangs for a long period of time. Each procedure takes approximately 30-40 seconds to execute when run separately. Outside of the stored proc/package world the SQL runs even faster. It appears I have some soft of memory limitation for packages/stored procs. Any help would be greatly appreciated. Thanks, Bill Stimeck bstimeck@xcurrent.com |