simple: insert,update,delete,search. Why using an another layer?
with jooq sql is still simple and still sql, jooq just adds static typing for it, so you cannot make a typo in your queries
Because those simple operations quickly start forming atomic batches - transactions. You monitor sql requests and see many same queries run over and over without actual data change between them, effectively asking same data over and over, which could be just cached. Just google what I've already suggested you. By the way, never used jooq mentioned by @Wizzardo , can't say whether all the hibernate benefits (and drawbacks) are applicable to it. Do your research
Обсуждают сегодня