3 ms·

Query optimisation is such an underated skill, imo it should be prioritised as a core skill for any backend developer

• jjeaff 7y ago
  It seems there are a lot of new "lead" developers out their that don't even understand rdbms, much less how to optimize them. A lot these days seem to be coming into the field thinking that SQL is old hat and nosql is the future. You should see this newly rebuilt e-commerce system I saw recently all built on mongo. The hoops jumped through and special functions created and work-arounds were just astounding. They basically had to build their own rdbms layer in node to interface with their mongo datastore. All this because the new hotshot developer convinced management that this was the only way to solve the DB bottlenecks they were having. ...because "MySQL will just never be able to query the product table in less than a few seconds since it has 'millions' of rows". An entire system rewrite to solve a problem that probably could have been solved with a few indexes. And now they are going to have to implement some things in MySQL again, because all the node.js code is getting overly complicated.
  • codegladiator 7y ago
    > "lead" developers out their that don't even understand rdbms Just lead ? I am interviewing "Full stack rockstars" who haven't who think SQL is unfit for every purpose. Frustrating, but a good filter.