Results of 1 - 3 of about 3 for creationDate (0.001 sec.)
- Schema 11831
- 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
...to reduce memory consumption. Microbenchmark: Using Timestamps We illustrate the difference in aggregation speed using the creationDate column of the LDBC Comment table on scale factor 300 . This table has approx. 554 million unordered timestamp values. We r...use a DATETIME to encode the values and run the query using the extract datetime function : SELECT avg(extract('day' FROM creationDate)) FROM Comment; Second, we use the VARCHAR type and use string operations: SELECT avg(CAST(creationDate[9:10] AS INTEGER))... - https://man.mtool.work/duckdb/2.0/guides/performance/schema.html
- Benchmarks 8631
- For several of the recommendations in our performance guide, we use microbenchmarks to back up our claims. For these benchmarks, we use datasets from the TPC-H benchmark and the LDBC Social Network Benchmark's BI workload . Datasets We use
...et's Comment table (20 GB .tar.zst archive, 21 GB when decompressed into .csv.gz files), while others use the same table's creationDate column (4 GB .parquet file). The TPC datasets used in the benchmark are generated with the DuckDB tpch extension . A Note... - https://man.mtool.work/duckdb/2.0/guides/performance/benchmarks.html
- S3 Express One 7422
- 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
...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 microbenchmarks of the performance guide ). Experiment File size Runtime Loading only from... - 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