Results of 1 - 3 of about 3 for experiment (0.001 sec.)
- Schema 11924
- Types It is important to use the correct type for encoding columns (e.g., BIGINT , DATE , DATETIME ). While it is always possible to use string types ( VARCHAR , etc.) to encode more specific values, this is not recommended. Strings use mor
...owing join operation: SELECT count(*) AS count FROM Comment c1 JOIN Comment c2 ON c1.ParentCommentId = c2.id; In the first experiment, we use the correct (most restrictive) types, i.e., both the id and the ParentCommentId columns are defined as BIGINT . In...the second experiment, we define all columns with the VARCHAR type. While the results of the queries are the same for both experiments, their ru...ng primary keys with the LDBC Comment table at scale factor 300 . This table has approx. 554 million entries. In the first experiment, we create the schema with a primary key, then load the data. In the second experiment, we create the schema without a pri... - https://man.mtool.work/duckdb/2.0/guides/performance/schema.html
- R-Tree Indexes 7980
- The spatial extension provides support for spatial indexing through the R-tree extension index type. Why Should I Use an R-Tree Index? When working with geospatial datasets, it is very common that you want to filter rows based on their spat
...f the dataset and the query patterns of your specific workload. The defaults should be good enough, but you if you want to experiment with different parameters, see the full list of options here . Example Here is an example that shows how to create an R-tr...memory limit set by the memory_limit configuration parameter. Tuning Depending on you specific workload, you might want to experiment with the max_node_capacity and min_node_capacity options to change the structure of the R-tree and how it responds to inse... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
- S3 Express One 7980
- In late 2023, AWS announced the S3 Express One Zone , a high-speed variant of traditional S3 buckets. DuckDB can read S3 Express One buckets using the httpfs extension . Credentials and Configuration The configuration of S3 Express One buck
...e any other S3 bucket: SELECT * FROM 's3://express-bucket-name--use1-az5--x-s3/my-file.parquet'; Performance The following experiments were run on a c7gd.12xlarge instance using the LDBC SF300 Comments creationDate Parquet file (also used in the microbench...marks of the performance guide ). Experiment File size Runtime Loading only from Parquet 4.1 GB 3.5 s Creating local table from Parquet 4.1 GB 5.1 s The “loading only”... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/s3_express_one.ht...
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work