Hi Ryan, There are lots of performance improvements in recent releases of jOOQ, including 2.6.3 and 3.0-RC1. They also include some improvements of mapping records to POJOs, where all reflection data is reused throughout the complete org.jooq.Result. This won't help if you're running small queries, of course.
As a general rule of thumb, jOOQ can never beat plain JDBC. It will always have a certain overhead. Generally, this can be said: 1. By default, jOOQ loads the JDBC ResultSet into memory and closes it early. This can cause some memory overhead, which can be circumvented by using fetchLazy() 2. jOOQ doesn't really support primitve types. It will always load wrapper types for ints, longs, etc. 3. Construction and rendering of queries comes with its cost. This has been greatly improved recently. 4. Reflection will always impair performance. You know your target domain model better than jOOQ. Use RecordMappers instead of Record.into() for tuning. Please, do post your findings when you're ready. There's always room for improement. Cheers Lukas 2013/4/5 Ryan How <[email protected]>: > I'm just doing an investigation into JOOQ performance with lots of small > queries on an embedded database. I was wondering if anyone else has got any > experience on JOOQ overhead in constructing queries and inserting results > into "Record" objects or POJOs. > > I expect the .into() operation could be quite expensive as it needs to use > reflection to work out what to do with the class. And it appears to be quite > a complicated algorithm. > > Anyway, I'll post some findings. I just wanted to see if anyone else had any > experience or data for this use case. > > Thanks, Ryan > > -- > 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/groups/opt_out. > > -- 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/groups/opt_out.
