SQLite Reader

About SQLite

SQLite is a lightweight, self-contained, serverless SQL database engine. It stores the entire database in a single file and is ideal for mobile apps, embedded systems, and small-scale applications. No separate server process is required to use it.

Properties

Tip: To change Reader properties double click on it.

Count Number of Records

When user run a transformation, software displays a progress bar and completion percentage.

To calculate this percentage, the software must first determine the total number of records in the source table.This record-counting operation can take a significant amount of time, especially for large tables, and may negatively impact overall performance.

Disabling Count Number of Records prevents the software from counting the records before processing begins, allowing the transformation to start immediately and potentially improving performance.