Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

[Info-Ingres] Why I love Vectorwise

26 views
Skip to first unread message

Martin Bowes

unread,
Jun 28, 2012, 8:33:49 AM6/28/12
to info-...@kettleriverconsulting.com

Hi All,

 

I have a table in an ordinary ingres database which has 450million rows. It has a three element primary key and we have to update one of those columns from -1 to zero. The question was are there any cases where we would get a key violation…

 

It took less time to transfer the table via a FIFO node to an installation with vectorwise, load it into to a dummy database, and then run the appropriate query there to determine the answer, then it took on the normal Ingres installation.

 

The query on Vectorwise took less than ten seconds!

 

We gave up on the standard installation.

 

Martin Bowes

Roy Hann

unread,
Jun 28, 2012, 9:07:56 AM6/28/12
to
Martin Bowes wrote:

> The query on Vectorwise took less than ten seconds!
>
> We gave up on the standard [Ingres] installation.

And the price is right too.

--
Roy

UK Actian User Association Conference 2012 will be on Tuesday June 11. 2013.
The latest information is available from www.uk-iua.org.uk.


0 new messages