20 months, 2K hours, 200K € lost. A story about resilience and sunk cost fallacy

Re:20 months, 2K hours, 200K € lost. A story about resilienc... by rowanG077 on Tuesday January 05, 2021 @08:05AM (#25645057)

I have never seen SQL being used as a key-value store. That most web apps use it like that is an incredible claim to me. Do you have any source for that?

[ Parent | on HN ]

Re:20 months, 2K hours, 200K € lost. A story about resilienc... by lmm on Tuesday January 05, 2021 @08:04PM (#25653563)

I've seen database profiling numbers from some of my clients, but obviously I can't publish those. To be clear all I'm claiming is that for most webapps the overwhelming majority of database queries are simple indexed column lookups, not that most webapps are putting document blobs in the database or using EAV style or anything like that.

[ Parent | on HN ]

Re:20 months, 2K hours, 200K € lost. A story about resilienc... by rowanG077 on Wednesday January 06, 2021 @04:31AM (#25656076)

Claiming that most queries are simple indexed columns lookups is a far cry from claiming most SQL databases are used as simple key-value stores.

[ Parent | on HN ]

Re:20 months, 2K hours, 200K € lost. A story about resilienc... by lmm on Wednesday January 06, 2021 @09:35PM (#25666599)

Well, "key-value store" means different things to different people. If most queries are simple indexed column lookups then that carries my original point: query parse time is actually a significant proportion of overall datastore request processing time.

[ Parent | on HN ]