3 ms·
OK, fair enough. And indeed, I use MySQL with MySQL Workbench in Ubuntu VMs. But still, Excel on equivalent Windows VMs pivots much faster.
by mirimir 9y ago
OK, fair enough. And indeed, I use MySQL with MySQL Workbench in Ubuntu VMs. But still, Excel on equivalent Windows VMs pivots much faster.
- Piskvorrr 9y agoPivoting 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.
- mirimir 9y agoIt 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.