I am new to rails, most of my experience is with desktop (Windows) GUI.
In Windows it is possible to bind s a listview to a database table. the GUI component hold a only the visible rows of the large table.
if the user scroll up/down to rows not in view, the control do a "behind the scenes" query in database to get the new rows to be displayed.
That allows the GUI to map arbitrary large tables with constance memory usage.
I am sure there must be a similar technique for rails, most likely with the aid of JQuery but I failed to find it.
I assume the terminology is different is the web world