4 ms·
Still not unique to spreadsheet.
by Piskvorrr 9y ago
Still not unique to spreadsheet.
- mirimir 9y agoWhat do you have in mind?
- Piskvorrr 9y agoThat custom solutions do not inherently require a server - "either it's Excel or it doesn't run on the workstation" is something that's actually easier to disprove today, with containers and whatnot. Custom solutions can be fully local, i.e. no network access required.
- mirimir 9y agoOK, 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.