TGViewer
Computer Science and Programming Computer Science and Programming @computer_science_and_programming · 140K subscribers
Post #1791 11.1K
Faster Dashboards with Multi-Column Approximate Sorting
Advanced multi-column sorting techniques using space filling curves (Morton and Hilbert encodings) and truncated timestamps can significantly improve query performance on columnar data formats. These methods enable approximate sorting across multiple columns simultaneously, allowing diverse dashboard queries to benefit from min-max indexes and row group pruning. Experiments on flight data show Hilbert encoding provides the most consistent performance across different query patterns, while sorting by truncated timestamps (year-level granularity) combined with Hilbert encoding works best for time-filtered queries.
  • ❤ 10
  • 👍 5
More from @computer_science_and_programming
  1. Oct 8, 2026Dark mode toggles: two states are enough • Lea Verou (Light, Dark, System). The core argum…
  2. Oct 3, 2026BYD says it will have a solid-state car next year, the earliest date anyone has given BYD…
  3. Oct 1, 2026Introducing G#: A Go-like language for .NET G# is a new open-source, Go-inspired programmi…
  4. Sep 30, 2026Chrome for Developers Chrome 146 introduces three notable features for web developers. Scr…
  5. Sep 26, 2026Introduction to Solon A comprehensive tutorial walks through building a REST API with Solo…
  6. Sep 25, 2026The strangler fig pattern: modernizing without a big-bang rewrite A detailed guide to the…
Threads Profile ViewerView any public Threads profile without an account.Open ThreadLook →Writing with AI? Make it sound human.Metric37 rewrites AI drafts so they read naturally. Free AI detector, 1,500 words free.Try Metric37 →