« Developer directory cleanup | Main | Degreeworks in progress audit flag problem »
March 23, 2012
Merged view: student
I added indexes to the local student tables for the merged view for student data. The performance was really bad without them. I added all of the logic to create the local tables in a procedure called p_create_local_tables. I updated the p_createstudent procedure and added a faculty or staff flag to the stusum table.
Posted by soukupm at March 23, 2012 2:01 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.)