I ran across this review, Vectorwise – Worth a Look? by Steve Miller and was wondering if anyone else had seen it or reviewed Vectorwise?
His non-complete evaluation resulted in:
The results I’ve gathered so far for my admittedly non-strenuous tests are nonetheless encouraging. My first experiment was loading a 600,000 row fact table with nine small star lookups from csv files. The big table load takes two seconds and all the queries I’ve attempted, even ones with a six table join, complete in a second or two.
The second test involved loading a 10 million+ row, four attribute, csv stock performance data set along with a 3000 record lookup. The big table imports in 7 seconds. Group-by queries that join to the lookup complete in under three seconds.
There is a 30-day free trial version for Windows.
BTW, can anyone forward me the technical white paper on Vectorwise? The last white paper I signed up for was a marketing document and not even a very good one of those.
I’ve been playing with Vectorwise for about 18 months. It’s very, very fast indeed. I also saw Steve Miller’s “review”. I’d be a lot more confident of his opinion if he had ever shown up on the Actian/Vectorwise forum to ask advice or to give his feedback. He’s evidently operating in a vaccum. Maybe he thinks record-breaking TPC-H performance should be intuitively obvious or maybe he thinks he knows it all. I have read some of his whitepapers too, and he does seem pretty clued-in, but I think he’s doing a very promising brand new product a great injustice with his tepid remarks.
My own (rather neglected) Vectorwise blog is at http://community.actian.com/forum/blogs/rhann, where I post some benchmark results of my own.
Comment by oldspanky — November 30, 2011 @ 11:20 am
Hi, there are a few available on:
http://www.actian.com/products/vectorwise#Resources
And yes, Vectorwise is insanely fast
Comment by nickm — November 30, 2011 @ 4:34 pm
@oldspanky – Really like the road sign! Will have to remember that. Thanks for the link!
@nickm Thanks for the pointer!
Comment by Patrick Durusau — November 30, 2011 @ 8:25 pm