Avoid eager association loading when fetching identifiers for mass indexing

Description

This discussion seems to suggest ID loading may lead to large queries that would fetch associations on top of just IDs… we need to confirm this.

I’m thinking maybe the generated SQL query includes joins for some eager associations, even though the result of those joins is not referenced in the SELECT clause? It’s really just a wild guess though, and a dubious one at that.

Anyway: we should try to reproduce that situation and see if there really is too many things being joined, and if so we should optimize ID loading.

Activity

Show:

Yoann Rodière January 22, 2024 at 9:55 AM

The original issue was on an application using Hibernate Search 5, so it's out of date.

Closing.

Out of Date

Details

Assignee

Reporter

Components

Priority

Created January 22, 2024 at 8:08 AM
Updated January 22, 2024 at 9:55 AM
Resolved January 22, 2024 at 9:55 AM