AW: AW: CTE with JOIN of two tables is much faster than a regular query

> -----Ursprüngliche Nachricht-----
> Von: Tim Cross <theophilusx(at)gmail(dot)com>
> Gesendet: Sonntag, 19. August 2018 04:57
> >
> > We're using object mapping / entity frameworks (e.g. XPO, Entity
> Framework Core). These frameworks support regular queries out-of-the
> box; a CTEs require additional effort and are more difficult to maintain.
> >
>
> Ah, another reason to avoid object mapping/entity frameworks! I guess
> really the same reason - loss of flexibility and expressive power.

While I agree that you loose control over certain details, we are overall quite happy using the frameworks.

The frameworks nowadays provide the ability to call procedures if required - but using the objects directly is more convenient for the developers. SQL procedures add (just like a CTE) an additional layer to the application design which needs maintenance. That's fine if it really helps overall but we try to avoid it if it isn't needed.

Regards
Klaus