Looking for a little advice here.
I'm creating a custom tab on a performance to replace an external db for tracking House Management information and attendance.
In addition to attendance data by price zone and ticket type (comp, sub, single, group, staff), we also track:
My question to you for the attendance data and the performance information (date/time, etc.), do you suggest we insert that into the newly created table or do you suggest we let the stored procedure simply display and refresh that data every time the tab is opened?
I believe speed will make your decision for you. If it is quick let the SP do it, otherwise I guess loading/updating a table nightly would be better. Just my two cents.