Don't want to generate unchanged file by Jooq

2024-05-28 Thread Muhammad Atif
I am using Programmatic Code Generated in Java Spring Boot. I don't want to generate whole schema again after a small change. At least file which doesn't have changes shouldn't be regenerated. This show hug change in PR review and hard to look after every bit of code. -- You received this mes

Re: Don't want to generate unchanged file by Jooq

2024-05-28 Thread Lukas Eder
Thanks for your message. jOOQ doesn't modify (touch) files which don't have any changes in them. On Tue, May 28, 2024 at 12:57 PM Muhammad Atif wrote: > This show hug change in PR review and hard to look after every bit of code. I'm afraid, I don't know what this means -- You received this

Re: Don't want to generate unchanged file by Jooq

2024-05-28 Thread Muhammad Atif
Actually in my team if someone has different Line Separator (CRLF/LF) configuration Jooq assumed there is a change in new file and generate it. Same for imports configuration. On Tuesday 28 May 2024 at 13:58:37 UTC+3 lukas...@gmail.com wrote: > Thanks for your message. > > jOOQ doesn't modify (

Re: Don't want to generate unchanged file by Jooq

2024-05-28 Thread Lukas Eder
You shouldn't modify generated sources! I understand that line separators may be changed by version control, so you could adapt the code generator to produce what you're using elsewhere: https://www.jooq.org/doc/latest/manual/code-generation/codegen-advanced/codegen-config-generate/codegen-whitesp

Re: Don't want to generate unchanged file by Jooq

2024-05-28 Thread Muhammad Atif
I solution of Line Separators and Space is resolved. Thank you. For Imports in IDE different people has different configuration for "Class count to use import with ''*". IDE make imports like import org.jooq.*; after Jooq added. On Tuesday 28 May 2024 at 15:20:45 UTC+3 lukas...@gmail.com wrote:

Re: Don't want to generate unchanged file by Jooq

2024-05-28 Thread Lukas Eder
jOOQ cannot possibly detect what kind of change you did manually, and respect that change. I'm not aware of any code generator that is able to keep arbitrary changes in generated code. IDEs can be configured to leave derived resources, such as generated code, alone and not touch their contents. I

Performance issues when bulk-inserting a lot of records with jOOQ

2024-05-28 Thread Giovanni Zotta
Hello there, This is not necessarily a jOOQ issue, but I wonder how you would best solve it when using jOOQ. If it's too off-topic, feel free to direct me somewhere else. We have been using jOOQ happily for a while in production; every day we have a couple of big bulk insert queries (insertin

Re: Performance issues when bulk-inserting a lot of records with jOOQ

2024-05-28 Thread Rob Sargent
> On May 28, 2024, at 9:16 AM, Giovanni Zotta > wrote: > > Hello there, > > This is not necessarily a jOOQ issue, but I wonder how you would best solve > it when using jOOQ. If it's too off-topic, feel free to direct me somewhere > else. > > We have been using jOOQ happily for a while in

Re: Performance issues when bulk-inserting a lot of records with jOOQ

2024-05-28 Thread Giovanni Zotta
AFAIK copy does not have a returning clause, which I need to retrieve the generated primary key IDs. Is there a way around that? On Tuesday 28 May 2024 at 22:36:08 UTC+2 robjs...@gmail.com wrote: > > > On May 28, 2024, at 9:16 AM, Giovanni Zotta > wrote: > > Hello there, > > This is not necess

Re: Performance issues when bulk-inserting a lot of records with jOOQ

2024-05-28 Thread Rob Sargent
> On May 28, 2024, at 1:41 PM, Giovanni Zotta > wrote: > > AFAIK copy does not have a returning clause, which I need to retrieve the > generated primary key IDs. Is there a way around that? > Yes. But my way is to assign ids in the client. If you’re using a sequence as Id generator then y

Re: Performance issues when bulk-inserting a lot of records with jOOQ

2024-05-28 Thread Jason Bennett
Taking 2 minutes to insert 200k records is a little high, I see speeds of around 35 seconds for 300k rows (and 12 seconds for 100k rows) with jOOQ. I'm not sure what transactions you are using, but if you are using Spring annotations, you can switch to using the TransactionTemplate and manually