100 million cells

Tags: #<Tag:0x00007f34380cc8f8>

My goal is to support 100 million cells. That is, one million rows and one hundred columns. I tested this using a simple fiddle: https://jsfiddle.net/36cpv5ng/. It seems to take a while to load and has less than snappy performance. Does Handsontable support partial loading via ajax? That is, request data from the server as it gets scrolled into view. Any suggestions on how to make this work would be greatly appreciated! :slight_smile:

Hi Mike,

I have to admit that this is a lot :slight_smile:

For cases like that, we’ve made this POC https://github.com/handsontable/handsontable/pull/6837
It not completed but surely can come in handy.

Hi Mike.

The POC is pretty complex but if you wish to share some feedback or have more questions than please connect with me by email (support@handsontable.com)