Archive for the ‘MySQL’ Category

MySQL vs. PostgreSQL for Data Warehouses that use Views

Tuesday, November 7th, 2006

As part of the Netezza replacement project I’ve been working on, I ran a quick evaluation of MySQL 5.x. before testing PostgreSQL. I didn’t have time to conduct a thorough evaluation, but I quickly found out that MySQL does not handle queries ran against views very well. I ran some tests by creating simple views against some very large tables (40+ million rows). Running a query against the base table was many times faster than running the same query against a view which did not even contain a WHERE clause. I’ll need to do some additional research, but it seems that the implementation of views in MySQL lags far behind the PostgreSQL implementation. It’s obviously not very surprising, since support for views was added to MySQL only in version 5.0.