Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Cannot share links to test cases. #215

Open
andyg2 opened this issue Aug 23, 2024 · 0 comments
Open

Cannot share links to test cases. #215

andyg2 opened this issue Aug 23, 2024 · 0 comments

Comments

@andyg2
Copy link

andyg2 commented Aug 23, 2024

The hashbang length makes it challenging to share a benchmark results on https://benchmark.clickhouse.com/#.........

Maybe if the assumption was that a metric is not selected (false) by default, the base64 encoded JSON could be reduced from this:

{
    "system": {
        "AlloyDB": false,
        "Athena (partitioned)": false,
        "Athena (single)": false,
        "Aurora for MySQL": false,
        "Aurora for PostgreSQL": false,
        "ByConity": false,
        "ByteHouse": false,
        "chDB (Parquet, partitioned)": false,
        "chDB": false,
        "Citus": false,
        "ClickHouse Cloud (aws)": false,
        "ClickHouse Cloud (aws) Parallel Replicas ON": false,
        "ClickHouse Cloud (Azure)": false,
        "ClickHouse Cloud (Azure) Parallel Replica ON": false,
        "ClickHouse Cloud (Azure) Parallel Replicas ON": false,
        "ClickHouse Cloud (gcp)": false,
        "ClickHouse Cloud (gcp) Parallel Replicas ON": false,
        "ClickHouse (data lake, partitioned)": false,
        "ClickHouse (data lake, single)": false,
        "ClickHouse (Parquet, partitioned)": false,
        "ClickHouse (Parquet, single)": false,
        "ClickHouse (web)": true,
        "ClickHouse": false,
        "ClickHouse (tuned)": false,
        "ClickHouse (tuned, memory)": false,
        "Cloudberry": false,
        "CrateDB": false,
        "Crunchy Bridge for Analytics (Parquet)": false,
        "Databend": false,
        "DataFusion (Parquet, partitioned)": false,
        "DataFusion (Parquet, single)": false,
        "Apache Doris": false,
        "Druid": false,
        "DuckDB (Parquet, partitioned)": false,
        "DuckDB": false,
        "Elasticsearch": false,
        "Elasticsearch (tuned)": false,
        "GlareDB": false,
        "Greenplum": false,
        "HeavyAI": false,
        "Hydra": false,
        "Infobright": false,
        "Kinetica": false,
        "MariaDB ColumnStore": false,
        "MariaDB": false,
        "MonetDB": false,
        "MongoDB": false,
        "Motherduck": false,
        "MySQL (MyISAM)": false,
        "MySQL": false,
        "Oxla": false,
        "ParadeDB (Parquet, partitioned)": false,
        "ParadeDB (Parquet, single)": false,
        "Pinot": false,
        "PostgreSQL (tuned)": false,
        "PostgreSQL": true,
        "QuestDB (partitioned)": false,
        "QuestDB": false,
        "Redshift": false,
        "SelectDB": false,
        "SingleStore": false,
        "Snowflake": false,
        "SQLite": false,
        "StarRocks": false,
        "Tablespace": false,
        "Tembo OLAP (columnar)": false,
        "TimescaleDB (compression)": false,
        "TimescaleDB": false,
        "Umbra": false
    },
    "type": {
        "C": false,
        "column-oriented": true,
        "PostgreSQL compatible": true,
        "managed": false,
        "gcp": false,
        "stateless": false,
        "Java": false,
        "C++": false,
        "MySQL compatible": false,
        "row-oriented": false,
        "ClickHouse derivative": false,
        "embedded": false,
        "serverless": false,
        "aws": false,
        "parallel replicas": false,
        "Azure": false,
        "analytical": false,
        "Rust": false,
        "search": false,
        "document": false,
        "somewhat PostgreSQL compatible": false,
        "time-series": false
    },
    "machine": {
        "16 vCPU 128GB": false,
        "8 vCPU 64GB": false,
        "serverless": false,
        "16acu": false,
        "c6a.4xlarge, 500gb gp2": true,
        "L": false,
        "M": false,
        "S": false,
        "XS": false,
        "c6a.metal, 500gb gp2": true,
        "192GB": false,
        "24GB": false,
        "360GB": false,
        "48GB": false,
        "720GB": false,
        "96GB": false,
        "1430GB": false,
        "dev": false,
        "708GB": false,
        "c5n.4xlarge, 500gb gp2": false,
        "Analytics-256GB (64 vCores, 256 GB)": false,
        "c5.4xlarge, 500gb gp2": false,
        "c6a.4xlarge, 1500gb gp2": false,
        "cloud": false,
        "dc2.8xlarge": false,
        "ra3.16xlarge": false,
        "ra3.4xlarge": false,
        "ra3.xlplus": false,
        "S2": false,
        "S24": false,
        "2XL": false,
        "3XL": false,
        "4XL": false,
        "XL": false,
        "L1 - 16CPU 32GB": false,
        "c6a.4xlarge, 500gb gp3": false
    },
    "cluster_size": {
        "1": true,
        "2": false,
        "4": false,
        "8": false,
        "16": false,
        "32": false,
        "64": false,
        "128": false,
        "serverless": false,
        "dedicated": false
    },
    "metric": "hot",
    "queries": [true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true]
}

base64 encoded is 4328 characters, over twice that of most url shorteners like bit.ly. Also too long for facebook or telegram to handle in a single message.

to this (all the false values removed)

{
    "system": {
        "ClickHouse(web)": true,
        "PostgreSQL": true,
    },
    "type": {
        "column-oriented": true,
        "PostgreSQLcompatible": true,
    },
    "machine": {
        "c6a.4xlarge,500gbgp2": true,
        "c6a.metal,500gbgp2": true,
    },
    "cluster_size": {
        "1": true,
    },
    "metric": "hot",
    "queries": [true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true]
}

just 602 character base64 encoded and well within the 2048 character rule of thumb most url shorteners etc

eyJzeXN0ZW0iOnsiQ2xpY2tIb3VzZSh3ZWIpIjp0cnVlLCJQb3N0Z3JlU1FMIjp0cnVlLH0sInR5cGUiOnsiY29sdW1uLW9yaWVudGVkIjp0cnVlLCJQb3N0Z3JlU1FMY29tcGF0aWJsZSI6dHJ1ZSx9LCJtYWNoaW5lIjp7ImM2YS40eGxhcmdlLDUwMGdiZ3AyIjp0cnVlLCJjNmEubWV0YWwsNTAwZ2JncDIiOnRydWUsfSwiY2x1c3Rlcl9zaXplIjp7IjEiOnRydWUsfSwibWV0cmljIjoiaG90IiwicXVlcmllcyI6W3RydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWUsdHJ1ZSx0cnVlLHRydWVdfQ

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant