Hello,
I notice that when I make some changes to production data that it takes about 15 minutes for our api web pages to reflect the changes. Say if I change the Title of a show from Romeo and Juliet to Hamlet, it would not reflect immediately.
So my question is, Is this because of the way our web pages were created? Or is there a web service that grabs all the data from Tessitura every so many minutes. If that is the case. what is the name of the procedure / service?
Christian
It sounds like your website is caching the those pages. You would need to clear the cache in order to see the changes take immediate effect.
Are you using your website or the /tessitura.asmx web service page?I've always seen changes in Tessitura reflected immediately via the actual web service call. Those are all directly to the database via stored procedures. As Jon said, you may have some kind of caching causing this symptom if you are looking at your website.
Good luck!
In the GetProduction, GetProductionDetail, GetPerformance and GetPerformanceDetail Calls, the data is cached by the API for 10 minutes.
From the API doc
Data retrieved for GetProductions is cached by the API for 10 minutes after the initial method call. Restarting the API's application pool in IIS will delete this cache.
Marty Jones
Database Administrator
Omaha Performing Arts 1200 Douglas Street
Omaha, Nebraska 68102
P 402.661.8469 | F 402.345.0222
Marty.Jones@omahaperformingarts.org
www.omahaperformingarts.org
For tickets, call Ticket Omaha at 402.345.0606
From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Christian Mauri Sent: Thursday, May 20, 2010 5:21 PM To: Martin A. Jones Subject: [Tessitura Web Forum] Lag in webapi update
You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!
Hi Christian,
Many of the API methods that pull performance information cache data. Here is a list of all API methods that cache data and for how long:
Kevin Sheehan
Documentation & Learning Resources Specialist
Tessitura Network
1 888 643 5778 ext 329 Office
ksheehan@tessituranetwork.com
This can be cleared if needed correct?
You can force the cache to clear by restarting the IIS application pool for your website, or by making a small change to the API's web.config file which causes .Net to recompile and pull all new data.
Gregg Stickney
Application Support Specialist/Manager Knowledgebase
From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Jon Ballinger Sent: Friday, May 21, 2010 10:17 AM To: Gregg Stickney Subject: RE: [Tessitura Web Forum] Lag in webapi update
From: Kevin Sheehan <bounce-kevinsheehan4372@tessituranetwork.com> Sent: 5/21/2010 8:47:09 AM
I was noticing the same things as Christian here when making changes, so thanks everyone for the explanations.
Duane
Thanks everyone. That is exactly what I needed.
Christian @ The Tech Museum