« Banner 7 Web Testing | Main | Weekly Report »
August 10, 2005
Continuing Banner 7 Testing
The Banner team has been hard at work testing Banner 7 before release in September so that we have a successful (hopefully bug free) launch. I've been able to add and drop classes from the web registration without any problems. We had a minor set back earlier in the week because web registration took around 5 mins or so to display the add/drop screen. It took me quite a while to figure out exactly where the slowdown was but I knew that it had something to do with a cursor that was selecting rows from spriden since we've encountered this type of problem many times in the past(because we use a view to the spriden table). So I ended up walking through the code line by line and looking at all the procedures and functions it was calling. I traced the major slowdown to a package called SOKLIBS. In this package, there's a cursor called advisorc that gets the name of the advisor. I added the compiler hint to it, and now the registration screen comes up in seconds. :)
Posted by soukupm at August 10, 2005 12:40 PM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)