Exago Logo
Search
Generic filters
Exact matches only
Performance and Scaling

Special Cartesian Processing

Part of the Performance and Scaling series.Exago BI can detect when a report query will return a Cartesian product or cross join and process the query in such a way to avoid returning a nonsensical table. This can considerably improve the end-user experience, but it can negatively ...

Tracking Execution Frequency with Monitoring

Part of the Performance and Scaling series.Execution Caching is a great way to reduce excessive database calls. For frequently accessed reports, you can set up caching so that the data is queried on a schedule, and users will access the cached data in a much more performant manner than ...

Configuration File Options and Optimizations

In order to decrease the amount of resources needed to handle the configuration information, especially in situations where a large number of complex database objects are present, the option to implement a static configuration has been introduced.

High Availability

This article will highlight recommendations for designing a highly available Exago environment. By creating multiple areas of redundancy, single points of failure can be eliminated. A system which is adaptable to component failures is highly available. This article will focus on how to make ...

Incremental Loading

Incremental loading limits the amount of data that is returned for each database query. This allows users to load reports incrementally, starting with a small set of rows and adding more in steps as desired.Incremental loading can shorten the amount of time it takes a report to load and be ...

Intro to Performance and Scaling

Welcome to the Performance and Scaling series. This is a series of articles and blog posts that aim to deliver advice and guidance for optimizing the performance of Exago BI.Internet software is very complex, often comprising dozens of servers and interconnected components. Taken ...

Measuring Database Network Latency

Part of the Performance and Scaling series.This article will discuss how to examine the Exago log file to determine the time it takes to retrieve data from a database. In this way you can isolate the performance of the network connection between the execution engine and the data ...

Monitoring Database Schema

The monitoring database has three tables that can be used to build reports. This article describes what data is stored, and how to interpret what you see.Entity-relationship diagram (ERD) for the monitoring databaseSystemStatistics The SystemStatistics table logs the available CPU ...

Monitoring Scheduler Load

The Monitoring Service can be used to capture Scheduler Service load and performance data.

Monitoring: Setup

Monitoring that allows report management, execution, and performance statistics for the web application and schedulers to be tracked in v2017.1+. Monitoring data is stored in local SQLite database files and can be reported on using Exago.

Monitoring: System Overview

The Monitoring system is structured in the following manner: Structure of the monitoring system Web Application Database The Web Application database stores data for report and user interface events. The type of data tracked depends on your configuration. At the Extract interval, the ...