Question about the benchmarks

[sanikolaev]

Hi

I have a question regarding the benchmarks posted on Siglens' Blog about being 54x faster than Clickhouse and Siglens' Blog about being 1025x faster than Elasticsearch.

Am I missing something, or does this query:

curl -X POST -d '{
    "searchText": "SELECT airport_fee, count(*) FROM trips GROUP BY airport_fee",
    "indexName": "trips",
    "startEpoch": "now-24h",
    "endEpoch": "now",
    "queryLanguage": "SQL"
}' http://localhost:5122/api/search | python3 -m json.tool

filter out all the data except for the last 24 hours, while this

SELECT airport_fee, count(*) FROM trips GROUP BY airport_fee

does not?

If this is correct, are there benchmark results for Siglens without this filtering?

[AndrewHess]

You're right, the first query takes 24 hours of data and the second query takes all the data. However, when we ran these benchmarks we ran the queries within 24 hours of starting the ingestion process and we also verified that the results returned by each corresponding set of queries was the same.