Skip to content
New issue

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

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

Already on GitHub? Sign in 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

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

No branches or pull requests

1 participant