Comment on MySQL has quesadillas?
realitaetsverlust@piefed.zip 2 months ago
People like to shit on MySQL, I get it, but this is just stupid. No relational database on this planet could handle such an unoptimized situation in adequate time.
Comment on MySQL has quesadillas?
realitaetsverlust@piefed.zip 2 months ago
People like to shit on MySQL, I get it, but this is just stupid. No relational database on this planet could handle such an unoptimized situation in adequate time.
Overspark@piefed.social 2 months ago
If you ignore the “no indexes” part (can’t request that in normal SQL anyway) then PostgreSQL absolutely can handle queries like that.
realitaetsverlust@piefed.zip 2 months ago
With indexes, so can MySQL or MariaDB. That’s why I said “unoptimized”. Postgres is certainly superior when it comes to more complex or analytical queries, but that’s because MySQL/MariaDB simply weren’t MADE for these kind of situations. And even postgres will struggle with an unoptimized, data-intensive workload. I’ve seen those in the wild.
It’s like shipping a formula 1 car into the desert and wondering why you’re last in the desert rally.