How Does Sales Cookie Scale Calculations To Very Large Data Sets?
Behind the scenes, Sales Cookie is able to scale calculation of commissions over large numbers (millions) of transactions using the following:
- Elastic Cloud Compute
- Parallel Data Processing
- Code Optimizations
Elastic Cloud Compute
The Microsoft Azure Platform provides near-infinite compute capacity, which automatically expands based on load. The following graph shows our average compute utilization over a 7 day period. As you can see, the average utilization remains at (or below) 1% capacity, with the highest spikes below 10%.
Parallel Data Processing
When running calculations, eligible transactions must be analyzed and processed. For example, we may need to find which rep to credit, calculate a score, etc. - for each transaction. Those steps are performed in parallel to ensure you get calculation results faster. Similarly, we must create database records to track credits and payouts - this is also done in parallel.
Code Optimizations
Our technical team routinely analyzes performance to find bottlenecks and increase code performance. Using various technical tools (such as database query analyzers or profilers), we squeeze as much performance as possible from Microsoft Azure and our code base, using techniques such as pre-fetching, indexing, or caching.
Related Articles
Getting Started With Sales Cookie - Payees
About This Guide This guide is designed to help you get started with Sales Cookie as a payee. For the admin starter guide, click here. This guide does NOT cover the many advanced options or capabilities found within Sales Cookie. However, we will ...Getting Started With Sales Cookie - Admins
About This Guide This guide is designed to help you get started as a Sales Cookie administrator. We assume that we've already configured one or more incentive plans for you. Looking for a starter guide for your payees instead? Click here. This guide ...How Can I Import Sales Cookie Data Into Google Sheets?
Sales Cookie offer a rich entity schema and APIs. Some solutions such as Power BI, Tableau, or Excel natively understand structured data. They also offer native support for JSON Web APIs such as OData. However, Google Sheets does not offer the same ...How Secure Is Sales Cookie?
Many SaaS products claim they are secure simply because they use SSL. The reality is that a SaaS solution requires many measures to be truly secure. Here is an overview of advanced security measures we implement to deliver world-class security. Some ...How Can I Embed Power BI Reports Into Sales Cookie?
Ready to share exciting commission reports with incredible visuals with other Sales Cookie administrators or payees? This article explains how you can embed Power BI reports within Sales Cookie. This article assume you have already created a Power BI ...