CODEWITHSUNDEEP
javamysql
Smriti mool
Smriti mool

Reputation: 139

Which is faster :Criteria query or native query?

I have a table Admin which might contain 1000 or even more records. Now, I am confused on which query to use so that the performance while fetching the entire data is not compromised.

I've tried fetching the data using native query and criteria query but only for small amount of data. I also studied the relevant questions but it didn't satisfy my question completely.

Which SQL query is faster and why?

Named Query, Native Query or Criteria API

Native query is faster than HQL/Criteria query in Hibernate

Which is better performance in hibernate native query or HQL

My entity class somehow looks like: 

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;

private String username;

private String emailAddress;

private String password;

private Character status;

Using Criteria Query:

 public List<Admin> fetchAdmin() {

    CriteriaBuilder builder = entityManager.getCriteriaBuilder();
    CriteriaQuery<Admin> criteria = builder.createQuery(Admin.class);

    List<Admin> adminList = entityManager.createQuery(criteria).getResultList();

    return adminList;
}

Using Native query:

@Query(value = "SELECT * FROM admin", nativeQuery = true)
List<Admin> fetchAllAdmins();

I expect, selection of a query that would fetch big data.

Upvotes: 5

Views: 7629

Answers (1)

Tim Biegeleisen
Tim Biegeleisen

Reputation: 522471

Based on what I have seen working with similar ORM tools, e.g. Hibernate, the raw SQL query would always be faster than the criteria query. But, assuming the same underlying SQL is being executed in both cases, the reason is that the criteria query is doing extra work with the result set. That is, the criteria query has to do the work of marshaling the SQL result into a collection of Java objects. This entails some serialization work, etc. Assuming you needed the result of the raw query as a collection of Java objects, you might not notice a meaningful difference in execution time between the two.

So, assuming the same query is being executed against your SQL database, the only difference in time is what happens on the Java side after the result set has been returned.

Upvotes: 6

Related Questions