What are the differences between archive and live data sources?

Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for SQLite, Navicat for MariaDB, Navicat for MongoDB, Navicat Premium

Live mode retrieves data from your servers whenever the data source is being used or loaded. It offers the convenience of real-time updates, with any changes in the underlying data reflected.

Archive mode retrieves data from your servers during the data source creation, and stored the retrieved data in the workspace for later use by building charts.