News for hackers. Stuff that matters.
Re:Datastream for BigQuery Preview by lmkg on Friday September 16, 2022 @02:07PM (#32869855)
This is a common thing for BigQuery to claim. It's quite fast for an analytics database, but it is not a transactional database. Even for static data, the simplest queries on the tiniest data still take 1/10th of a second or so, and realistic queries run in the 1-5s range.

Basically you could use BigQuery to build tools supporting human-in-the-loop processes (BI reports, exec dashboards), and you could call those "real-time" to the humans involved. But it will not support transactional workloads, and it does not provide SLAs to support that. I don't know about this particular feature, I'm guessing seconds but maybe minutes.

Re:Datastream for BigQuery Preview by yolo3000 on Friday September 16, 2022 @05:21PM (#32872154)
They are also introducing a sort of search/indexing soon, which will probably speed up certain types of queries.