I was wrong about spreadsheets (2017)

Re:I was wrong about spreadsheets (2017) by mirimir on Friday July 12, 2019 @02:00AM (#20418598)

In MySQL, maximum row size for non-text columns is 65,535 bytes. MySQL is limited to 4096 columns per table, and 1017 columns per table if the InnoDB engine is being used.

Excel's limits are 16384 columns and 1048576 rows.

I'm talking wimpy hardware here, I admit. Basically, VirtualBox VMs on a quad-core i5 box with SSD and 8GB RAM. With the VM having three cores and 6GB RAM. But it was the same wimpy hardware for Windows 7 and Ubuntu.

[ Parent | on HN ]

Re:I was wrong about spreadsheets (2017) by hef19898 on Friday July 12, 2019 @03:06AM (#20418853)

Oh, the day Excel got rid of the 64k line limit! Was a very sweet day!

[ Parent | on HN ]

Re:I was wrong about spreadsheets (2017) by michaelper22 on Friday July 12, 2019 @01:21PM (#20422419)

Notwithstanding the row length and column count limits, did you also give MySQL more memory? Setting InnoDB buffer pool size to 3 or 4 GB might help; its default is about 134 MB.

[ Parent | on HN ]

Re:I was wrong about spreadsheets (2017) by mirimir on Friday July 12, 2019 @07:55PM (#20425580)

I think so, but don't remember for sure.

[ Parent | on HN ]