limit « MySQL « JPA Q&A

1. using Limit of mysql

2. 61 table join limit with MySQL

Without more details about your database structure and what you want to achieve it is very hard to make sensible suggestions. Of course you can avoid joins by not using inheritance mapped via joined subclasses. Basically if you want inheritance, that is you want an entity hierarchy, and your underlying database structure uses the table per subclass model, then you get ...