#346 Low performance with big tables

Not planned
wont-fix
nobody
None
5
2014-11-03
2013-05-27
No

Surely because of some issue with JPA tab provider. Look at this thread:
https://sourceforge.net/p/openxava/discussion/419689/thread/53327248/

Discussion

  • Javier Paniza

    Javier Paniza - 2013-08-14

    I have tested the performance against a 600,000 rows table with JPATabProvider and the response time (as Firebugs says) is around 600 ms, for querying and drawing the corresponding html, including the count. I tried with JDBCTabProvider and the performance is just the same. I tested using an AS/400 as database.

    Therefore, the performance of JPATabProvider with huge tables is very good.

    The problem of the user in the thread could be related by this Hibernate bug:
    https://hibernate.atlassian.net/browse/HHH-2176

    But this is a Hibernate bug, not an OpenXava one. When we'll upgrade the Hibernate version this bug will be solved. In the meantime the DB2 users can user JDBCTabProvider if they face performance problems.

     
  • Javier Paniza

    Javier Paniza - 2013-08-14
    • status: open --> wont-fix
     

Log in to post a comment.