Hi Vishwanath (I've noticed, this discussion accidentally went off-list. Putting the mailing list in CC again, redacting the content)
Indeed, the auto-generation of an alias for derived tables in SelectQueryImpl.asTable() should be faster. I thought there was a pending issue to fix this, but I cannot seem to find it. I've added an issue here: https://github.com/jOOQ/jOOQ/issues/6714 The problem is, we need an alias for derived tables, and if you don't provide it explicitly, that's probably the best way to go right now (discussion will be in #6714) You can always work around this problem by creating an explicit alias for your subquery, e.g. by calling Select.asTable("alias") or table(select).as("alias"). I hope this helps, Lukas 2017-10-17 13:03 GMT+02:00 Vishwanath M: > Hi Lukas, > > This way of accessing is name was really helpful . Now am facing issues in > the below code > > > Most of time is spent when i convert a select to table and the profiler > shows it spends most of the time in org.jooq.impl.Tools.hash . May i know > the reason ? > > Thanks, > Vishwanath.M > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
