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?
Those two cents are worth gold to me.
Thanks!
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Travis Armbuster Sent: Friday, July 22, 2016 2:45 PM To: Dot Krebs Subject: Re: [Tessitura Technical Forum] Advice: Custom Tab
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.
From: Dot Krebs <bounce-dotkrebs9366@tessituranetwork.com> Sent: 7/21/2016 12:44:40 PM
PERFID
Act2Runtimetime
PerformanceCode
EndTime
PerformanceType
ShowRuntime
Venue
AccessiblePerformance?
GateCount
#ofBenefitingPatrons
%Capacity
#ofLoopDevicesUsed
PerformanceDate
#ofRadioDevicesUsed
PerformanceTime
AccessibleSeatsUsed
HouseManager
LargePrintProgramsUsed
TicketSalesManager
WeatherConditions
UsherTeam
OutsideTemperature
#ofVolunteers
TheatreTemperature2hrsBeforeDoorsOpen
IfHouseOpenLate
TheatreTemperaturePreshow
HouseOpen
TheatreTemperature30minsin
Pre-ShowBegin
LobbyCondition
Pre-ShowEnd
TheatreCondition
Pre-ShowRuntime
CoatCheckIncome
Act1Begin
PatronNotes
Act1End
OperationsNotes
Act1Runtime
HousekeepingNotes
IntermissionBegin
MiscellaneousNotes
IntermissionEnd
PreShow?
IntermissionLength
PreShowAttendance
Act2Begin
PostShow?
Act2End
PostShowAttendance
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!