Member Login
  • Products
    • Qure Suite
    • Qure Analyzer
    • Qure Optimizer
  • Downloads
    • Qure Analyzer (Free)
    • Qure Optimizer (Free Trial)
  • Support
    • Contact Support
    • Frequently Asked Questions
    • Limitations and Known Issues
  • Resources
    • SQL Server Articles
    • Whitepapers
    • Videos and Tutorials
    • Attend an Online Demo
    • inTune eMagazine
    • SQL Server Tuning Blog
  • Learn More
    • About Workload Tuning
    • SQL Server Tuning
    • SQL Server Performance
    • SQL Server Performance Tuning
    • Tips
  • Company
    • About DBSophic
    • Management
    • Partners
    • News
    • Success Stories
    • Customer Testimonials
    • Selected Customers
  • Contact Us

Retalix

Qure optimized performance of key business transactions at Retalix

Retalix (RTLX on NASDAQ) is a global provider of integrated software solutions for the food, fuel, and consumer goods retail and distribution industries. With an installed base in over 50 countries, Retalix solutions are installed in supermarkets, groceries, convenience stores, and fuel stations, as well as foodservice, grocery, convenience products, and fast moving consumer goods distribution organizations around the world.

Qure's analysis process at Retalix was not induced by a specific performance problem, but rather as part of an ongoing effort to maintain database and applications performance. "We work to maintain our clients' database performance in order to preserve our applications' high level of service and data availability, thus preventing serious performance problems", says Shmuel Witman, VP of Development at Retalix. He elaborates that "We work to maintain database performance while continuously adding new features and business models to our applications. These additions can potentially degrade performance on top of the increase in data and user volumes. Therefore, we perform ongoing database optimization processes to counteract these potentially harming effects."

Mr. Witman specifies that "When talking about performance, we focus on business transactions end-to-end. This is the way we have measured the performance gain after implementing Qure's recommendation. We didn't look at the database tier only, but measured a transaction across all tiers of the application."

Qure optimized the performance of Retalix's Grocery product line and generated a hundreds of performance optimization recommendations. Retalix implemented the recommendations that were the easiest and fastest to implement. Accordingly, Retalix concentrated on a subset of application's key business transactions and implemented recommendations only within the database itself without making changes to other application tiers.

Mr. Witman concludes by saying that "Qure could considerably assist DBAs, during both the maintenance and the development phases of the application's life. Qure's benefits would be even more substantial for applications where a DBA was not an integral part of the development process." The results of the optimization process are displayed in the graph on the top-right corner of this page.

The subset of Qure recommendations that were implemented by Retalix is deployed as part of the next version of StoreLine.net on sites of many Retalix clients.

<< Back to case study list

Improvement to business transactions

Measured end-to-end on the QA environment

new table new graph

 

© 2011 DBSophic Ltd. All rights reserved. | Legal