Results of 1 - 2 of about 2 for checksums (0.000 sec.)
- Calculating a Database Checksum 11228
- To calculate a database checksum, use a commutative operation such as bit_xor on all columns, all rows, and all tables. First, create a table macro that performs this for each table: CREATE OR REPLACE MACRO table_checksum(table_name) AS TAB
...generating a SQL file: .mode list .headers off .once checksum_all_tables.sql SELECT printf('CREATE OR REPLACE TABLE table_checksums (checksum UHUGEINT);') UNION ALL SELECT printf('INSERT INTO table_checksums FROM table_checksum(''%s'');', table_name) FRO...late the checksum for the database: .read checksum_all_tables.sql SELECT bit_xor(checksum) AS database_checksum FROM table_checksums;... - https://man.mtool.work/duckdb/2.0/guides/snippets/database_checksum.html
- Environment 7485
- The environment where DuckDB is run has an obvious impact on performance. This page focuses on the effects of the hardware configuration and the operating system used. Hardware Configuration CPU DuckDB's officially supported architectures a
...th other file systems such as ext4. On Windows, we recommend using NTFS and avoiding FAT32. DuckDB databases have built-in checksums, so integrity checks from the file system are not required to prevent data corruption. Network-Attached Disks Special care... - https://man.mtool.work/duckdb/2.0/guides/performance/environment.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work