5 ms·
FYI, this query took 81 seconds: select count(*) from trips where fare_amount > 0 Presumably this is Hacker News load?
by gubby 6y ago
FYI, this query took 81 seconds:
select count(*) from trips where fare_amount > 0
Presumably this is Hacker News load?
- bluestreak 6y agowhile HN load is high, this is just because poor implementation on our side. Filters are single threaded, not yet vectorized in any way. This will be fixed eventually to bring in line with queries that we've already optimised
- TheTank 6y agoTanks for the feedback. WHERE queries are slow indeed. This is not because of the load but rather because WHERE clauses are not yet implemented under the fast path. Currently they run under an old model which is single-threaded which is why they are painfully slow. We will make these as fast as the rest soon.