Forum Discussion

GregHertling's avatar
GregHertling
New Contributor III
8 months ago

Data Cell update limit on Table Views

Hi, is there a limit on the number of cells that can be updated through Table Views?  We have a large table, 250 rows by 140 columns.  When we try to update all values at once, there are many cells that do not update.  When we only load 10 or so rows at a time, it updates all values correctly.

thanks,

Greg

Spreadsheet
  • Krishna's avatar
    Krishna
    Valued Contributor
    8 months ago

    GregHertling  - In General SQL can handle 1024 Columns, in OS there could be a limitation either you need to reach to support or you can perform a trail and error. BTW Dumping all data in single table does not good design. Try to Normalize the table and use join to pull the data. Hope this helps.