Hello, We've made quite a few improvements over the last 1.5 years in terms of performance. In particular, a couple of those issues related to inefficient hashCode() (and equals()) implementations were addressed - if I remember correctly, mostly in jOOQ 3.2. Is upgrading to jOOQ 3.5 not an option for you?
Best Regards, Lukas 2014-12-17 11:03 GMT+01:00 Дмитрий Прайвит <[email protected]>: > > Hi! > I got a problem. getValue method performs extremly slow because of slow > hashCode method realisation. > In our project, we convert every result from jOOQ (ExecuteQueryCursor res > = NgQueryPkg.executeQueryCursor(factory, ...) to our inernal fomat. > NgQueryPkg is generated by jOOQ. In this conversation we retrieve fields > from Result using getValue method: > //converter function > public static QueryResponse fromJooqQueryCursor(Result<Record> > cursorQueryResult,... > { .... > for (final Record record : > cursorQueryResult.sortAsc(QUERY_RECORD_COMPARATOR)) { > String synonym = record.getValue( > QueryRecordField.SCHEMA_SYNONYM.name(), String.class); > String schemaCode = record.getValue( > QueryRecordField.ENTITY_SCHEMA_CODE.name(), String.class); > //other getValue() invocations > This is what profiler shows me: > > <https://lh4.googleusercontent.com/-rHzJ_AVypiY/VJFSqoBw7XI/AAAAAAAAADA/ehmJ0bqnl3E/s1600/%D0%91%D0%B5%D0%B7%D1%8B%D0%BC%D1%8F%D0%BD%D0%BD%D1%8B%D0%B9.jpg> > > > > > > > > > > > > > > > > > > In AbstractQueryPart in hashCode method there is a comment: > "// This is a working default implementation. It should be overridden by > // concrete subclasses, to improve performance" > Who must override it? Me? Or internaj jOOQ AbstractQueryPart's > implimentation classes? > If so, how could I specify jOOQ to use exact realisation of AbstractQueryPart > when giving me result? > > Wish you could help me, because currently our system works very slow! > Thank you! > > P.S. We'r using jOOq 2.6.7 > P.P.S Sorry if the question is stupid - I'm new in jOOQ) > > -- > 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. > -- 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.
