Live data from Hacker News

Kth: High-Performance Selection Algorithms for Go

github.com

1–7 of 7 posts

Re: Kth: High-Performance Selection Algorithms for Go

#5
post #4

This looks interesting but I can't think of an use case. Can you share some examples where it could be useful?

Yes! A typical use case is to efficiently implement ORDER BY LIMIT N in SQL databases in a way that doesn’t require sorting the entire column just to get those first N items.

Re: Kth: High-Performance Selection Algorithms for Go

#6
post #5
post #4

This looks interesting but I can't think of an use case. Can you share some examples where it could be useful?

Yes! A typical use case is to efficiently implement ORDER BY LIMIT N in SQL databases in a way that doesn’t require sorting the entire column just to get those first N items.

i assume this go code runs in the client since pg does not support golang server side. why would a client side ordering be faster than doing in the database?

Re: Kth: High-Performance Selection Algorithms for Go

#7
post #5

Earlier quoted context omitted.

Yes! A typical use case is to efficiently implement ORDER BY LIMIT N in SQL databases in a way that doesn’t require sorting the entire column just to get those first N items.

i assume this go code runs in the client since pg does not support golang server side. why would a client side ordering be faster than doing in the database?

This is to implement a database, not use one.