database sort vs. programmatic java sort

by

If you are retrieving a subset of all the database data, for example displaying 20 rows on screen out of 1000, it is better to sort on the database. This will be faster and easier and will allow you to retrieve one page of rows (20, 50, 100) at a time instead of all of them.

If your dataset is fairly small, sorting in your code may be more convenient if you want implement a complex sort. Usually this complex sort can be done in SQL but not as easily as in code.

The short of it is, the rule of thumb is sort via SQL, with some edge cases to the rule.

More Related Contents:

  1. Java8 Collections.sort (sometimes) does not sort JPA returned lists
  2. What is the internal sorting technique used in comparator and comparable interfaces and why? [duplicate]
  3. How to sort by two fields in Java?
  4. No Persistence provider for EntityManager named
  5. How to sort a HashMap in Java [duplicate]
  6. Sort a Map by values
  7. Collections.sort with multiple fields
  8. Error creating bean with name ‘entityManagerFactory’ defined in class path resource : Invocation of init method failed
  9. What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?
  10. Android-java- How to sort a list of objects by a certain value within the object
  11. JPA Query selecting only specific columns without using Criteria Query?
  12. Default fetch type for one-to-one, many-to-one and one-to-many in Hibernate
  13. @PreUpdate and @Prepersist in hibernate/JPA (using session)
  14. Spring – Is it possible to use multiple transaction managers in the same application?
  15. JPA getSingleResult() or null
  16. JPA how to make composite Foreign Key part of composite Primary Key
  17. Is it faster to add to a collection then sort it, or add to a sorted collection?
  18. Spring JPA @Query with LIKE
  19. Hibernate/JPA DB Schema Generation Best Practices
  20. How to use Collections.sort() in Java?
  21. Java Enums, JPA and Postgres enums – How do I make them work together?
  22. Difference between a “jta-datasource” and a ” resource-local ” datasource?
  23. java.lang.NoSuchMethodError: javax.persistence.spi.PersistenceUnitInfo.getValidationMode()Ljavax/persistence/ValidationMode;
  24. Persisting UUID in PostgreSQL using JPA
  25. JpaRepository caches newly created object. How to refresh it?
  26. Batch inserts with JPA/EJB3
  27. Sorting ArrayList of Objects by Object attribute
  28. What’s the difference between the IN and MEMBER OF JPQL operators?
  29. Spring, JPA, and Hibernate – how to increment a counter without concurrency issues
  30. How to auto detect entities in JPA 2.0

Leave a Comment