Re:PartiQL: One query language for all your data
by therapon on Friday August 02, 2019 @02:05AM
(#20590926)
It looks like the first query run in the REPL takes more time (startup cost). Subsequent runs of that query return around 5ms. Even a query like `SELECT * FROM 1` when executed immediately after starting the REPL will take longer than usual. Even running non-query expression, e.g., `1 + 1` immediately after starting the REPL will take more time to complete than usual.
The time reported by the REPL can be misleading.
There is work that we definitely need to do on performance as we develop PartiQL. Performance is something we have been considering since inception and we will keep considering as we go forward.
Re:PartiQL: One query language for all your data
by justicezyx on Friday August 02, 2019 @11:33AM
(#20593790)
I mean modern infrastructure's user experience is very poor compared to decades ago's PC based software...
Re:PartiQL: One query language for all your data
by monsieurbanana on Friday August 02, 2019 @04:10AM
(#20591356)
> Latency matters to everyone, always.
I used to do a lot of BigQuery for analytics. Latency in BigQuery is crap and clearly not it's selling point, we're not talking ms here, we're talking seconds at a minimum. Yet it's a really nice database for it's use cases.
Re:PartiQL: One query language for all your data
by vgt on Sunday August 04, 2019 @12:09AM
(#20604376)
We've improved our floor latency by a factor of 5 since two years ago, we've introduced clustering, and newly introduced BI engine gets you into dozen digit millisecond range, so give it a try again :)
(Product manager on BigQuery)
In the era of 64-core processors, scaling horizontally is meaningless for 99.9% of architecture designs. Latency matters to everyone, always.
Trivial queries taking nearly 1/10th of a second on modern kit is absolutely atrocious, and shows a total lack of awareness of performance as a feature.