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?
It seems to me that doing an update to the table regularly would be less overhead – especially because once a performance is over, you wouldn’t expect attendance figures to change much or quickly. The only caveat would be if there are performances for which you are doing after-the-fact scanning, or where scanning on the night doesn’t go as planned and you end up doing a lot of catch-up.