Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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.



We have been doing some tests with http://www.monetdb.org/Home. We saw inserts per second in the range of 50k/sec on a laptop.


mmap. +1. 10MB source tarball. -1. Looks like it's worth a test. Thanks for the reference.


what is the technical difference? I would have thought the dbms takes care of a performant storage/organization system for me.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: