"Art S. Kagel" <kagel@bloomberg.net> wrote in message
news
an.2004.11.11.17.33.12.913569.1355@bloomberg .net...
> 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!
Yes, it's impressive technology.
It was first announced on cdi in June, but I was asked to particiapte in
testing over a year ago.
So it's strange that Madison's team was not brought on board earlier.