Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Poor performance of ReadAllquery

391969May 9 2003 — edited May 1 2008

I understand that that a ReadAllQuery always fires SQL against the database aswell as checking the cache. What i don't get is that when the cache contains all of the available database records, the ReadAllQuery takes a considerable time to execute. What is causing this delay?
If i run the generated SQL directly against the database, the result set is returned instantly. Toplink however can take nearly a minute to return it's vector of objects even though all of the objects exist in the cache. If i use checkCacheOnly option on the query i get the objects instantly.
What extra processing is occuring here and causing the delay?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 29 2008

Added on May 9 2003

#application-servers, #toplink-jpa

12 comments

1,345 views