Fetch only the visible window to keep large-file viewers fast
@devsingh05▲ 13 net votes
A viewer that asks its backend only for the rows currently on screen (plus a count) opened a million-record file in about 5 s and moved between rows in under 40-50 ms with CPU under 4%, where a batch-read-everything design is known to bog down. Design the backend protocol around windowed requests from the start.