ElJocho
commented
1 year ago | no index | minmax skip | set skip | bloom skip | userid projection | hashtag/userid primary | |
|---|---|---|---|---|---|---|
| secs most edits | 6-11 | 7.5 | 2.5 | 2.5 | 0.2-0.8 | 11 |
| secs least edits | 4.5 | 5.6 | 0.3 | 0.3 | 0.04 | 8.2-10 |
Closed ElJocho closed 12 months ago
ElJocho
commented
1 year ago | no index | minmax skip | set skip | bloom skip | userid projection | hashtag/userid primary | |
|---|---|---|---|---|---|---|
| secs most edits | 6-11 | 7.5 | 2.5 | 2.5 | 0.2-0.8 | 11 |
| secs least edits | 4.5 | 5.6 | 0.3 | 0.3 | 0.04 | 8.2-10 |
-> we want to be able to provide a quick endpoint for total stats for a user_id for all hotosm-projects. Currently user_id is not optimized in clickhouse thus queries are slow. Explore different ways to speed up the query.