3 ms·
It's more work for the computer to process data stored as "rows" than data stored as columns. Think of how a disk is organized. If you abandon MySQL and store
by advocate1 14y ago
It's more work for the computer to process data stored as "rows" than data stored as columns.
Think of how a disk is organized.
If you abandon MySQL and store data as columns you can load a trillion rows.
But forget I mentioned this.
- aw3c2 14y agowhat is the technical difference? I would have thought the dbms takes care of a performant storage/organization system for me.
- dfragnito 14y agoWe have been doing some tests with http://www.monetdb.org/Home http://www.monetdb.org/Home. We saw inserts per second in the range of 50k/sec on a laptop.
- advocate1 14y agommap. +1. 10MB source tarball. -1. Looks like it's worth a test. Thanks for the reference.