3 ms·
I don't know where the "twice as slow" number for postgresql comes from. My the experience is different. Wildly different. For simple "keystore" loads, both are
by sergiosgc 14y ago
I don't know where the "twice as slow" number for postgresql comes from. My the experience is different. Wildly different. For simple "keystore" loads, both are at the same performance class. For anything more complicated, typical relational database scenarios, mysql folds and is one or two orders of magnitude slower.
The query planner's inability to push restrictions down the tree into subqueries alone prevents many typical real world queries.
The way I see it, mysql is trapped between NoSQL and proper relational databases