Client Situation - CSS Corp started analyzing the infrastructure of the newly built campaign site of the ice cream brand on the following aspects, to identify the bottlenecks.
- Query Performance Monitoring
- Infrastructure and Resource Capabilities
- High Availability Techniques Used and their bottlenecks
The analysis showed that the slow queries were due to missing indexes and fragmentation of tables. To optimize the queries, indexes were created on the missing columns to avoid a full-scan of the tables, which improved the performance.
About Client -The client is a multinational consumer goods company with product lines that include foods, beverages, cleaning agents and personal care products. Today, the consumer goods giant sells food, home care, refreshments, and personal care products in over 190 countries. Headquartered in London, United Kingdom and Rotterdam, the Netherlands, the client has subsidiaries in over 90 countries and employs more than 170,000 people.
FILL THE FORM TO DOWNLOAD CASE STUDY