top | item 46908686

(no title)

kijin | 24 days ago

In a typical CRUD web app, any query that takes milliseconds instead of microseconds should be viewed with suspicion.

In a more charitable interpretation, maybe the parent is talking about sub-100ms total round trip time for an API call over the public internet.

discuss

order

kccqzy|24 days ago

But OP never said it's a CRUD app. Maybe OP did some experimentation with OLAP use cases.

vagab0nd|23 days ago

OP here. Roughly 50GB in db size. Fairly standard queries (full-text search + filters). Most queries are on the order of 10-100ms. Some more complex ones involving business logic exceeds 100ms.

This is well within my budget, but it sounds like there might be room for improvements?