Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 335448 - CacheBasedValueHolder for Collections should use IN not perform multiple queries
Summary: CacheBasedValueHolder for Collections should use IN not perform multiple queries
Status: CLOSED DUPLICATE of bug 337319
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P2 major (vote)
Target Milestone: ---   Edit
Assignee: Nobody - feel free to take it CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-01-26 09:48 EST by Gordon Yorke CLA
Modified: 2022-06-09 10:20 EDT (History)
1 user (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Gordon Yorke CLA 2011-01-26 09:48:36 EST 
Currently when a CacheBasedValueHolder is executed it issues a read object query for each of the items in the collection.  If the Elements are no longer in the cache this can result in terribly inefficient querying.

The solution is to page the elements into IN queries as we do for Batch reading.
Comment 1 Gordon Yorke CLA 2011-04-13 15:02:33 EDT 

*** This bug has been marked as a duplicate of bug 337319 ***
Comment 2 Eclipse Webmaster CLA 2022-06-09 10:14:49 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink
Comment 3 Eclipse Webmaster CLA 2022-06-09 10:20:52 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink