Collections should be loaded by default using "lazy collection fetch" instead of "extra lazy collection" fetch

Description

If an entity has a collection (either entities or components), then loading the collection from audit tables one query is issued per element of collection rather than issuing one query for the whole collection. Because of this while loading huge object graphs from audit tables, large number of queries are issued and taking long time to load the data.

Default option to load collections should be changed from "extra lazy collection fetch" to "lazy collection fetch".

More details can be found at the discussion in the forum:
http://community.jboss.org/message/567086

Environment

Works fine with in-memory database like H2 but for MySQL5 generates too many queries.

Status

Assignee

AdamA

Reporter

Srinivas Nandina

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

3.6.0

Priority

Minor
Configure