Maximum rows in OX table

tochy2010
2013-08-07
2013-08-09
  • tochy2010
    tochy2010
    2013-08-07

    Hi,

    Please what is the maximum number of rows that can be handled by OX version 2.2
    I am currently working on a project that may involve importing data with up to 4million rows.

    Also, can OX list view manage the data (CRUD and Search) without errors??

     
  • Javier Paniza
    Javier Paniza
    2013-08-09

    Hi Toch,

    I am currently working on a project that may involve importing data with up to 4million rows.

    Then, you will have to write an import process that works efficiently with 4million rows, but it is your code, out of the scope of OpenXava.

    can OX list view manage the data (CRUD and Search) without errors?

    Yes, OX2.2 can display and manage huge tables with no problems.


    Help others in this forum as I help you.
    Need more help? Get OpenXava professional support.

     
  • Hi Toch,

    We are using OX with tables containing close to two millions rows. While OX can handle it, you should avoid unfiltered list display, as the calculation of totals and counts can take several seconds (depending on the DBM and its environment).

    Federico

     
    Last edit: Federico Alcantara 2013-08-09