Question

Maximum number of rows for a table?

Forms

Updated September 6, 2018

asked on September 6, 2018

Hi,

I was wondering if there a maximum number of rows that forms can handle for a table?

I have a lookup that queries SQL and has the potential to return a lot of data (maybe 6-10 thousand rows). I was hoping to display this using something like datatables.net and allow the user to download results as a csv.

At the moment it seems to me like querying this much data just causes the form to lock up waiting for it to load. The SQL executes very quickly but the form just freezes.

Are there any tricks I need to look at? Like would it help to hide the table until it populates and only displaying it after applying the datatable library?

Thanks in advance for any feedback or suggestions :)

0 0

Replies

replied on September 6, 2018

I don't think a single page will be able to handle anything close to that many rows. Even 1,000 rows is going to take a long time just to populate.

The issue isn't so much about Forms but rather the browser. Chrome can handle more DOM elements (like table rows) than IE, but even Chrome would probably fail with 6-10 thousand.

Even if it did work well enough that you could view the page, you're looking at probably several minutes to even add the data to the page.

The real solution in situations like this is paginating the data because browsers just aren't designed to show that much content all at once.

0 0

replied on September 6, 2018

Yeah, in terms of paginating it, that's what I hoped to use https://datatables.net/ for. I was wondering if it's possible to have the table hidden, populate it, paginate it and then display but I think it might still be too big. I guess for this many rows you need to fill the table dynamically (like an 'endless scroll' type of thing). I would love any suggestions on how I might achieve something like this.

I might be able to change our requirement and cap the displayed row count but I need the user to be able to download the data as a CSV. Would there be a way that I can still have a csv of the data available for download? (I can dump it out to disk and have a download link but I'm trying to think how I handle authenticated access to it. Alternatively maybe something with my own web service and Ajax but again I'm fuzzy on how to handle the authentication as it contains sensitive data.

0 0

You are not allowed to follow up in this post.

Question

Question

Maximum number of rows for a table?

Replies

Sign in to reply to this post.