Results of 1 - 3 of about 3 for thumb (0.001 sec.)
- Environment 11459
- 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
...guarantees for these platforms. 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 memory per thread. For example, if you use 8 threads, you need at least 1 GB of me...sing network-attached disks: If you are writing to disk, it is important that the disks are reliable. As a general rule of thumb, this is true for locally attached disks, and block storage in the cloud. If your workload is larger than memory and/or fa... - https://man.mtool.work/duckdb/2.0/guides/performance/environment.html
- INSERT Statements 9505
- INSERT statements are the standard way of loading data into a relational database. When using INSERT statements, the values are supplied row-by-row. While simple, there is significant overhead involved in parsing and processing individual I
...ements. 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., avoid using INSERT... - https://man.mtool.work/duckdb/2.0/data/insert.html
- Parquet Tips 6920
- Below is a collection of tips to help when dealing with Parquet files. Tips for Reading Parquet Files Use union_by_name When Loading Files with Different Schemas The union_by_name option can be used to unify the schema of files that have di
...RE clause of the query. However, there is some overhead associated with reading the metadata in each group. A good rule of thumb is to ensure that the number of row groups per file is at least as large as the number of CPU threads used to query that f... - https://man.mtool.work/duckdb/2.0/data/parquet/tips.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work