Reviews (1-1 of 1)
December 05, 2015
Score 4 out of 10
VectorWise was tested and the quick response for SQL involving massive data was one of the attractive features. The cost was also low as compared to the commercial databases. But after implementing multiple projects in VectorWise we learned it handles parallel ETL loads and high concurrent user poorly. Most of the time with users logged in to BI tools on top of VectorWise the database became dormant and we had to restart the server. ETL loads when run for a single project would run fine, but with multiple project ETL starting in parallel, the databse would respond very poorly. After close to two years we decided to move away from VectorWise and decommissioned VectorWise. VectorWise was a bad candidate to be the enterprise data warehouse database. For a data mart or ODS it may be a suitable candidate.
Read this authenticated review
VectorWise is suitable to be a departmental data mart database or an operational data store (ODS). It is not suitable for enterprise data warehouse database.