data-atom icon indicating copy to clipboard operation
data-atom copied to clipboard

Better performance for large result sets

Open lukemurray opened this issue 8 years ago • 2 comments

  • Need to stream the results in when possible.
  • Need to not add thousands of elements to the DOM when they are not visible

Maybe look at some nice table/grid control that will play nice with atom

lukemurray avatar May 13 '16 12:05 lukemurray

This would be great! I was thinking of looking into "lazy fetching", where you can fetch the results via a button X rows at a time, or with a "fetch all" button. I'll have to look at the data access libraries here and see what is possible.

DSpeckhals avatar May 13 '16 14:05 DSpeckhals

Some SQL editor tools wrap users query in a

SELECT ( {users_query} ) 
LIMIT {user_specified_page_limit: default 500}

jpotts18 avatar Jul 13 '17 17:07 jpotts18