Very slow View and column name lagged behind after new update 1.1.453

cna · June 9, 2018, 9:05pm

I updated my rstudio to Version 1.1.453. After I updated it, "View" became so slow and column names are always way lag behind side scrolling. Vertical scrolling takes some seconds to show which way slower than the previous version. note that my table is 10000*40.
I used to work faster in the old version.
(I am using mac os 10.13.5) .
please fix this issue.

RuReady · June 9, 2018, 9:39pm

It's a known issue

github.com/rstudio/rstudio

RStudio View() slow with very wide data (>100 columns)

opened 01:08AM - 21 Nov 17 UTC

closed 04:38PM - 16 Nov 18 UTC

jmcphers

bug data viewer

We've had a few reports that `View()` can make RStudio very slow when data is ve…ry wide. We knew about this performance issue in RStudio 1.0, and so we truncated data to 100 columns in that release in order to keep performance at acceptable levels. However, many people with wide data indicated that they'd prefer to see all their columns (even if it was slow), so in 1.1 we lifted the 100 column limit. Predictably, it's now slow for wide data. There are a few approaches we could take to addressing this: 1. Do some performance analysis to see why DataTables (which is the underlying library that renders the data to the DOM) is so slow as the number of columns increase. (We might not be able to do anything about a potential bottleneck without contributing a patch to DataTables.) 2. Add code to do column virtualization; just as today rows are paged in dynamically, we could show a small set of columns in the DOM and then page in more as the user scrolls left or right. (It may or may not be possible to add columns on the fly smoothly). 3. Restrict the number of columns visible to a small number (say, 50), and give the user an affordance for manually selecting the columns to view. (This UX might not be ideal.) 4. Implement the grid using a different library that scales better for wide data. (This would take a long time, but on the other hand we already do so much custom data fetching and rendering that our dependency on DT is smaller than it might seem.) No good options, but wide data is common enough (and performance poor enough) that we should address this in the upcoming release if we can.

kevinushey · June 12, 2018, 12:50am

Thanks for the bug report. We'll plan to investigate some of the slowness that has crept into the Data Viewer in the RStudio v1.2 preview, and see if we can improve the situation before release.