This project is discontinued - it's a demo. All data is fake and resets on refresh.
Querly
Mina Park
8 days ago
Progressive fill of real rows beats a moving estimate. Users tolerate "still loading more" but they distrust a number that changes under them. If you must show a total, label it clearly as an estimate until final.
Yes - and keep sort order stable while streaming. Nothing worse than rows jumping around as new ones arrive. Append-only, then re-sort once on completion if needed.
A fast LIMIT 100 preview while the full query runs is a great middle ground, as long as you visually mark it as a preview. We show the preview instantly and swap to full results with a subtle transition.