Results of 1 - 9 of about 9 for Bestpractice (0.009 sec.)
- Schema – DuckDB 13822
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...es stored in larger data types will not take up larger sizes on disk, but they will take up more memory during processing. Bestpractice Use the most restrictive types possible when creating columns. Avoid using strings for encoding more specific data items....Join column schema type Example value Query time BIGINT BIGINT 70368755640078 1.2 s BIGINT VARCHAR '70368755640078' 2.1 s Bestpractice Avoid representing numeric values as strings, especially if you intend to perform e.g., join operations on them. Constrain...ce of queries as DuckDB does not rely on these indexes for join and aggregation operators (see indexing for more details). Bestpractice Do not define constraints unless your goal is to ensure data integrity. Microbenchmark: The Effect of Primary Keys We illu... - https://man.mtool.work/duckdb/1.3/guides/performance/schema.html
- Environment – DuckDB 9436
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
.... Hardware Configuration CPU DuckDB works efficiently on both AMD64 (x86_64) and ARM64 (AArch64) CPU architectures. Memory Bestpractice Aim for 1-4 GB memory per thread. Minimum Required Memory As a rule of thumb, DuckDB requires a minimum of 125 MB of memor...s errors cased by the underlying file system. Warning Avoid running DuckDB in read-write mode on network-attached storage. Bestpractice Fast disks are important if your workload is larger than memory and/or fast data loading is important. Only use network-ba... - https://man.mtool.work/duckdb/1.3/guides/performance/environment.html
- File Formats – DuckDB 9185
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
.... Parquet The queries on the TPC-H benchmark run approximately 1.1-5.0× slower on Parquet files than on a DuckDB database. Bestpractice If you have the storage space available, and have a join-heavy workload and/or plan to run many queries on the same datase...10 row groups will achieve full parallelism. It is also beneficial to keep the size of individual Parquet files moderate. Bestpractice The ideal range is between 100 MB and 10 GB per individual Parquet file. Hive Partitioning for Filter Pushdown When queryi... - https://man.mtool.work/duckdb/1.3/guides/performance/file_formats.html
- Data Import – DuckDB 8412
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...rming row-by-row inserts (even with prepared statements) is detrimental to performance and will result in slow load times. Bestpractice Unless your data is small (<100k rows), avoid using inserts in loops. 関連キーワード DuckDB using Import Methods importing... - https://man.mtool.work/duckdb/1.3/guides/performance/import.html
- INSERT Statements – DuckDB 8142
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ing individual INSERT statements. This makes lots of individual row-by-row insertions very inefficient for bulk insertion. Bestpractice As a rule-of-thumb, avoid using lots of individual row-by-row INSERT statements when inserting more than a few rows (i.e.,... - https://man.mtool.work/duckdb/1.3/data/insert.html
- Partitioned Writes – DuckDB 8142
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...use the partitioned_write_max_open_files configuration option (default: 100): SET partitioned_write_max_open_files = 10 ; Bestpractice Writing data into many small partitions is expensive. It is generally recommended to have at least 100 MB of data per part... - https://man.mtool.work/duckdb/1.3/data/partitioning/partitioned_writes.html
- Indexing – DuckDB 7891
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...he required parts of the index. Therefore, having an index will not cause any slowdowns when opening an existing database. Bestpractice We recommend following these guidelines: Only use primary keys, foreign keys, or unique constraints, if these are necessar... - https://man.mtool.work/duckdb/1.3/guides/performance/indexing.html
- Samples – DuckDB 7891
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...nbiased sampling. This is not a big problem when the reservoir is very small, but becomes costly when the sample is large. Bestpractice Avoid using reservoir sampling with large sample sizes if possible. Reservoir sampling requires the entire sample to be ma... - https://man.mtool.work/duckdb/1.3/sql/samples.html
- SELECT Statement – DuckDB 7891
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...); DELETE FROM t WHERE i % 2 = 0 ; SELECT rowid FROM t ; rowid 1 3 5 7 9 The rowid values are stable within a transaction. Bestpractice It is strongly advised to avoid using rowids as identifiers. If there is a user-defined column named rowid , it shadows th... - https://man.mtool.work/duckdb/1.3/sql/statements/select.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work