News for hackers. Stuff that matters.

A comment on Look for the duct tape. Parent comment

Re:Look for the duct tape by mirimir on Wednesday March 28, 2018 @03:46AM (#16696140)
OK, fair enough. And indeed, I use MySQL with MySQL Workbench in Ubuntu VMs. But still, Excel on equivalent Windows VMs pivots much faster.
[ Parent | on HN ]
Re:Look for the duct tape by Piskvorrr on Wednesday March 28, 2018 @06:01AM (#16696591)
Pivoting is a feature, not a solution; plus it might pivot well on tiny datasets, but for anything over 100k rows, it scales about as well as a brick.
[ Parent | on HN ]
Re:Look for the duct tape by mirimir on Wednesday March 28, 2018 @04:43PM (#16701735)
It wasn't that I had too many lines, but too many columns. As I recall, a few hundred columns and maybe 50-100K lines. Even after increasing the field/column limit in MySQL, the query wouldn't complete. But in Excel on an equivalent VM, it computed in a few minutes.
[ Parent | on HN ]