Quick comparison of MyISAM, Infobright, and MonetDBRecently I was doing a little work for a client who has MyISAM tables with many columns (the same one Peter wrote about recently). The client’s performance is suffering in part because of the number of columns, which is over 200. The queries are generally pretty simple (sums of columns), but they’re ad-hoc (can access any columns) and it seems tailor-made for a column-oriented database. I decided
Analyzing air traffic performance with InfoBright and MonetDB
