Diagnosing performance issues
The practice of performance tuning can range from being simple to being very complex, but most issues are easy to resolve through effective design and by applying simple troubleshooting steps and techniques. Sometimes problems are obvious and can be resolved easily. In more challenging cases, we must consider the possible causes and then eliminate possibilities to discover the remaining options. Fortunately, in most models, performance issues can be addressed without extensive experimentation. If your models have large volumes of data, many tables, complex relationships, or layers of complex calculation logic, you have a higher likelihood of running into performance problems that you'll need to sort out.
Processing and query-related performance
The xVelocity In-Memory Analytics Engine consists of a storage engine and a query engine that work in tandem to return query results and perform calculations. A fundamental understanding of these components is helpful...