Thank you for quick responce! Well, now, after your assurance, that such performance problems are solved in jOOQ 3, we will try to migrate to latest version, but unfortunately it's a hard work for us - many things must be overwrited.
среда, 17 декабря 2014 г., 13:26:01 UTC+3 пользователь Lukas Eder написал: > > 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] > <javascript:>>: >> >> 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] <javascript:>. >> 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.
