[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: [eclipselink-users] Does EclipseLink avoid the restrictions ofToplink Essentials? (Performance issues)
- From: "Mathias Walter" <mathias.walter@xxxxxxx>
- Date: Thu, 31 Jul 2008 23:58:30 +0200
- Delivered-to: email@example.com
- Importance: Normal
- Thread-index: Aci+ssGBGQ/UtR8HSmex9Xn/qZJUyg0pVstQ
> 2.) Pagination (MySQL)
> I am using a MySQL 5 Database. JPA supports pagination
> through the methods
> "setFirstResult(...)" and "setMaxResults(...)". When
> executing a query with
> firstResults and maxResults being set, Toplink Essentials
> will NOT create an
> SQL statement with a LIMIT clause (the LIMIT clause is used
> to constrain the
> number of rows). So all database rows are fetched. Will
> EclipseLink behave
> the same or does it produce a "correct" SQL statement that
> includes the
> LIMIT clause? For me, this is a very important requirement.
There is a feature request in Eclipse Bugzilla already:
I needed the same function and enhanced the proposed patch.
Maybe you can vote for this issue.