3 ms·
They added a new column for each new chunk of data. In this scenario Excel, with its 16 384 columns is better than say PostgreSQL which has a limit of only 16 0
by rvba 6y ago
They added a new column for each new chunk of data. In this scenario Excel, with its 16 384 columns is better than say PostgreSQL which has a limit of only 16 000 :)
If they stored the data in rows with some additonal column(s) to mark date and source, they would probably run out of rows in Excel... but here is a clear example of someone not knowing how to use the tool. So they could also make errors in a real database.
Also who knows if this wasnt done on purpose to show better numbers and later blame it on a "computer bug".