chibenwa commented on PR #2514:
URL: https://github.com/apache/james-project/pull/2514#issuecomment-2490348291
@vttranlina does JOOQ offers some way to do lazy fetching in a reactive
fashion and does it help?
Discussed with @yadd:
```
execute(select().from(MESSAGES))
```
Is syntactically equivalent to:
```
// Execute as many time as needed
execute(select().from(MESSAGES))
.sortOn(UID)
.where(UID > highestUID so far)
.limit(pageSize)
```
IE given a mailbox with 2500 messages we execute the select 3 times.
WHat it effectively does in implement paging within the application.
We could:
- .collectList when working with users, user mailboxes and maybe even
mailboxes. COunt of entity is low.
- However maybe messages would be the only place where such kind of
fetching really make sense ?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
