Eclipse Community Forums: EclipseLink » EclipseLink and pagined queries

Help

Home

Home » Eclipse Projects » EclipseLink » EclipseLink and pagined queries

Show: Today's Messages :: Show Polls :: Message Navigator

EclipseLink and pagined queries [message #1001292]

Wed, 16 January 2013 07:08

Philippe
Messages: 100
Registered: July 2009

Senior Member

Hello,

Is a way to perform an efficient pagined query with the mysql platform
(InnoDb driver) ?

My queries use
- the setMaxResults / setFirstResult methods to limit the number of results.
- one or several indexes (BTREE).

After several tests, it seems to me that EclipseLink uses no index to
optimize the queries . Is EclipseLink run through the entire base?
Is the use of a cursor could make queries optimized ?

Other question: setMaxResults / setFirstResult and ScrollableCursor seem
limited to integer values. Is a way to perform my pagined queries on a very
large database?

--
Philippe Bastiani

Report message to a moderator

[Message index]

		EclipseLink and pagined queries By: Philippe on Wed, 16 January 2013 07:08
		Re: EclipseLink and pagined queries By: Chris Delahunt on Wed, 16 January 2013 10:06
		Re: EclipseLink and pagined queries By: Philippe on Sun, 20 January 2013 05:53

Previous Topic:	Multi-threaded overwrites
Next Topic:	ClassLoader problem using JPA with Native Eclipselink project file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 04:14:33 EDT 2013