@ChShersh@Franc0Fernand0 You don’t, use a database that’s tuned to process this type of data. Sorry but 100 gb a day is nothing. You can decode that data into a database and have it indexed likely in under 10 mins.
@igor_alexandrov I still want to be able to query a service layer to determine its “health” beyond just the http server. And the response should include why it’s “unhealthy”. I like red/green all the way down.
@brankopetric00 If ANY query takes more than 60 seconds, you’re doing it WRONG, and I don’t care HOW much data you’re dealing with. And yes, 99% of the time, it’s the query or the design of the underlying tables that’s the issue, not the database.
Missing indexes are a massive whoopsie.
@roblittledotca I’ve had bugs last years with no clearly identifiable cause and no clear way to 100% reproduce them.
I’ve also had bugs outlast major software versions.