News for hackers. Stuff that matters.

A comment on SQLite 3.32. Parent comment

Re:SQLite 3.32 by iagovar on Saturday May 23, 2020 @01:37PM (#23284808)
Well, for me with my personal PC with a quad core and 24gb DDR3, it gets unusable for about 1 million rows, but it's true that most of my datasets have around 10 columns or so.
[ Parent | on HN ]
Re:SQLite 3.32 by nojito on Saturday May 23, 2020 @01:42PM (#23284850)
You should be using PowerPivot in Excel.

Here's a video showing rapid pivots of 100m row dataset

https://youtu.be/0WwFJ0Zg3d8?t=2285

[ Parent | on HN ]
Re:SQLite 3.32 by iagovar on Saturday May 23, 2020 @02:04PM (#23285007)
Mmm, I was using PowerQuery and then use the editor to do the transformations (don't remember exact names sorry), and I just couldn't cope with it.
[ Parent | on HN ]