SQL and ORM frameworks are like ASM and higher-level languages :O

  • 8
    Not really.

    Yes ORM can make some queries easier but once you need something more elaborate you most likely will need to go to SQL unless you want to write a lot more code.

    Sql is pretty good at reducing overhead code, at least for anything complex.

    For basic queries or small datasets ORM could work but I have yet to find one that handles complex joins and conditions on very large data sets without being very verbose or slow.

    And by large I mean 100 million rows at least or more per table.
  • 2
    @Voxera so much so, I'll write a blanket ORm but I won't include an actual framework for it, you get to a point the damn thing is the bottle neck and end up ripping it out anyway.
Add Comment