On Thu, 11 Nov 2004 14:45:02 -0500, Rob Vorbroker wrote:

See www.coppereye.com.

It an innovative indexing technology that they've packaged into a datablade.
It is incredibly efficient at adding keys to an index and search speed is not
seriously impacted. That means you can add dozens of indexes and data load
speed is still several orders of magnitude faster than using BTREE indexes.
Means you can add indexes to optimize currently marginal queries which you
had been avoiding doing because of the impact on data maintenance windows.
It also means that maintenance can be performed without disabling or dropping
indexes first. One test showed something on the order of a 20+hour load with
indexes in place took 6 hours to drop indexes, load, and rebuild indexes and
using coppereye indexes without dropping the same load was performed in just
under an hour!

VERY interesting technology, but I can't get anyone around here to look at it
because of the support -vs- finger pointing issues.

Art S. Kagel

> For those of us who didn't go to the conference - what's coppereye? ---
> Madison Pruet <mpruet@comcast.net> wrote:
>
>> Art,
>>
>> It's too early to know exactly how Coppereye will be supported by IBM. We
>> (i.e. developement) didn't even know about Coppereye until the last user
>> conference.
>>
>> M.P.
>>
>>
>> "Art S. Kagel" <kagel@bloomberg.net> wrote in message
>>
> newsan.2004.11.11.08.50.25.907379.1355@bloomberg .net...
>> > On Wed, 10 Nov 2004 22:44:13 -0500, John Carlson
>> wrote:
>> >
>> > > On 10 Nov 2004 04:25:39 -0800,
>> vavavoom_th14@yahoo.co.uk (Traveller2003)
>> > > wrote:
>> > >
>> > >>Hi All,
>> > >>
>> > >>I need a very very strong strong drink. Last
>> time I was this surprised
>> was
>> > >>when spurs won the league even though I was not
>> born :-) Makes
>> interesting
>> > >>reading. Comments please and more noise people.
>> More noise :-)
>> > >>
>> > >>
>> > >>
>>>http://www.it-analysis.com/article.php?articleid=12379
>> > >>
>> > >>
>> > >>Traveller
>> > >
>> > >
>> > > Interesting article . . . I liked the final
>> quote where . . . .
>> > >
>> > > "To conclude: there is good news and there is
>> good news - on the one
>> hand
>> > > there is new technology emerging to support
>> Informix users, while on the
>> > > other IBM is listening."
>> > >
>> > > Think IBM is listening? Seems that way . . .
>> >
>> > One bit of bad news, IBM will not support
>> Coppereye in the same way that
>> > Informix supported Excaliber. This means that if
>> there is a problem IBM
>> and
>> > Coppereye will be finger pointing all over out
>> cringing heads. Ah well,
>> > nothing's perfect.
>> >
>> > Art S. Kagel
>>
>>
>>
>>
>>
> =====
> Rob Vorbroker Phone: 513/336-8695 Vorbroker
> Consulting, Inc. Fax: 513/336-6812 www.vorbroker.com
> robv@vorbroker.com sending to informix-list