3 ms·
I’ve had a first-of-class linuxian excellent developer but junior, tell me that we need Kafka because our SQL requests took 3 seconds. It should be a single IN
by eastbound 3y ago
I’ve had a first-of-class linuxian excellent developer but junior, tell me that we need Kafka because our SQL requests took 3 seconds.
It should be a single INSERT, but through an ORM that multiplies it. The only upside of Kafka is not having the ORM…
- j16sdiz 3y agoIf you need pre-fetching and 2-phase-commits, a database designed for queues can easily work 3x better than a genetic SQL database. That's being said, Kafka is not one of them.
- gemstones 3y agoIn this case, you are the senior that needs to bypass the ORM and just use whatever raw parameterized query support exists in your ORM of choice.
- DaiPlusPlus 3y ago> whatever raw parameterized query support exists in your ORM of choice That doesn't help with conditional-predicates - that's another major shortcoming in SQL.