{"id":4995,"date":"2024-03-07T13:59:17","date_gmt":"2024-03-07T13:59:17","guid":{"rendered":"https:\/\/staging.elixirrdigital.com\/us\/?post_type=case_study&p=4995"},"modified":"2026-03-16T10:38:53","modified_gmt":"2026-03-16T10:38:53","slug":"burger-king","status":"publish","type":"case_study","link":"https:\/\/staging.elixirrdigital.com\/us\/case-studies\/burger-king\/","title":{"rendered":"Reducing database query times from 25 seconds to under 4 for Burger King"},"content":{"rendered":"\n
\n
\n
\n
\n Back to Case Studies<\/a> <\/div>\n

\n Case Study<\/p>

\n Burger King<\/h1> <\/div>\n
\n
\n

Performance tuning and regular database maintenance led to considerable reduction in average query times; from 15-25 seconds down to 2-4 seconds.<\/p>\n <\/div>\n <\/div>\n<\/div>\n

\n \"\" <\/div>\n <\/div>\n <\/section>\n\n\n\n\n\n
\n
\n

About the brand<\/h2>\n

Restaurant Services, Inc. (RSI) is the supply chain manager for the BURGER KING\u00ae system and the exclusive purchasing agent for the vast majority of products and distribution services used by RSI\u2019s members \u2013 BURGER KING\u00ae restaurant owners in the United States. Burger King has restaurant locations throughout the US and more than 100 other countries.<\/p>\n

The challenge<\/h2>\n

Burger King relies on their Netezza data warehouse to support a series of daily reports delivered to senior executives every morning. Under a previous support contract, SLA\u2019s were regularly missed, and overall performance was suffering.<\/p>\n

The solution<\/h2>\n

With Elixirr Digital Managed Services, the Netezza servers were stabilized.<\/p>\n

The results<\/h2>\n

SLA\u2019s for Executive Reporting data integration routines were improved. \u00adThe need for manual intervention during nightly processing was significantly reduced. \u00adPerformance tuning and regular database maintenance led to a considerable reduction in average query times; from 15-25 seconds down to 2-4 seconds. On average, severity 1 issues are responded to in 5 minutes or less.<\/p>\n <\/div>\n <\/div>\n<\/section>\n\n\n\n

\n
\n
\n Improving customer data accuracy & service efficiency for the Boston Red Sox <\/div>\n Previous<\/a> <\/div>\n
\n Next<\/a>
\n Achieving sub-second response times for Capitalogix\u2019s trading platform <\/div>\n <\/div>\n <\/div>\n
\n See all case studies<\/a> <\/div>\n<\/section>\n\n\n \n
\n
\n
\n

\n Related case studies<\/h2> <\/div>\n
\n
\n View all case studies<\/a> <\/div>\n <\/div>\n<\/div>\n
\n
\n
\n
\n
\n \"\" <\/div>\n
\n
\n

\n Case Study <\/p>\n \n

\n Driving 45% of traffic through organic search for a B2B events agency\n <\/h2>\n <\/a> <\/div>\n
\n
\n Generating monthly inbound lead growth through SEO-led website redesign. <\/div>\n
\n
\n
\n Content Strategy <\/div>\n
\n SEO <\/div>\n
\n User Experience <\/div>\n
\n UX Design <\/div>\n
\n Website Migration <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n<\/article>\n <\/div>\n
\n
\n
\n \"\" <\/div>\n
\n
\n

\n Case Study <\/p>\n \n

\n Turning complex global content into a governed, scalable system\u00a0\n <\/h2>\n <\/a> <\/div>\n
\n
\n Establishing a streamlined process for high-quality content creation and governance. <\/div>\n
\n
\n
\n Standards & Certification <\/div>\n |<\/span>\n
\n Content Marketing <\/div>\n
\n Digital Strategy <\/div>\n
\n User Experience <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n<\/article>\n <\/div>\n
\n
\n
\n \"A <\/div>\n
\n
\n

\n Case Study <\/p>\n \n

\n Creating a faster, more intuitive search experience for Bidwells users\n <\/h2>\n <\/a> <\/div>\n
\n
\n Redesigning search and listings pages to create a smoother, more intuitive user experience. <\/div>\n
\n
\n
\n User Experience <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n<\/article>\n <\/div>\n <\/div>\n
\n
\n \n\n\n<\/g>\n<\/svg>\n <\/div>\n
<\/div>\n
\n \n\n\n<\/g>\n<\/svg>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/section>\n\n\n \n
\n
\n
\n
\n
\n

\n Featured Service<\/p>

\n UX Research & Analysis<\/h3> <\/div>\n
\n
\n

Gain deep user insights to refine design, usability, and engagement.<\/p>\n <\/div>\n

\n UX Research & Analysis<\/a> <\/div>\n <\/div>\n<\/div>\n <\/article>\n
\n
\n
\n

\n Featured Service<\/p>

\n Website Design<\/h3> <\/div>\n
\n
\n

Develop stunning, user-friendly websites that align with business goals.<\/p>\n <\/div>\n

\n Website Design<\/a> <\/div>\n <\/div>\n<\/div>\n <\/article>\n <\/div>\n <\/div>\n <\/section>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":6,"featured_media":4996,"template":"","related_service":[90],"related_industry":[137],"class_list":["post-4995","case_study","type-case_study","status-publish","has-post-thumbnail","hentry"],"acf":[],"card":"
\n
\n \"\" <\/div>\n
\n
\n

\n Featured Case study <\/p>\n \n

\n Reducing database query times from 25 seconds to under 4 for Burger King\n <\/h2>\n <\/a> <\/div>\n
\n
\n
\n
\n Food & Drink <\/div>\n |<\/span>\n
\n Managed services <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n<\/article>\n","_links":{"self":[{"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/case_study\/4995","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/case_study"}],"about":[{"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/types\/case_study"}],"author":[{"embeddable":true,"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/users\/6"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/media\/4996"}],"wp:attachment":[{"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/media?parent=4995"}],"wp:term":[{"taxonomy":"related_service","embeddable":true,"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/related_service?post=4995"},{"taxonomy":"related_industry","embeddable":true,"href":"https:\/\/staging.elixirrdigital.com\/us\/wp-json\/wp\/v2\/related_industry?post=4995"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}