EclipseLink should use the LIMIT function when using the MySQLPlatform DatabasePlatform class and setting a max rows return value. You can verify the SQL EclipseLink generates for a query by enabling logging at FINE or Finest as described here: http://wiki.eclipse.org/EclipseLink/Examples/JPA/Logging
If Limit is not being used, you may need to verify the MySQL DBplatform class be used by specifying <property name="eclipselink.target-database" value="MySQL"/> in your persistence.xml, and check the EclipseLink version is 2.2 or greater.
If this doesn't help, please you describe the query you are executing, the SQL generated, the target-platform specified and the EclipseLink version you are using.
Chris thank you for your quick reply and sorry for the delay of these
I'm using EclipseLink 2.2.3 with the Mysql 5.1.18... And, yes I've
activated the finest level of logs !
The 2 values seem properly binded into the LIMIT clause. But finally, I
think my benchmarks are not significant ... because my queries have many
joins! So, I need to rethink theses ones to help JPA or use native
And, what about my second question: What is the best approach to support
pagined queries in a big database (I need to save 1-2000000 of records per
day during a year) ?