Re: More on Informix from Bloor Research.

Let me start off by saying that I don't want to piss in anyone's chips... Art S. Kagel said: > 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 Search speed is not seriously impacted for certain kinds of queries. It is definitely visibly impacted on some types of queries. > load > speed is still several orders of magnitude faster than using BTREE > indexes. But several orders of magnitude slower than an unindexed table. > 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! I had a very different experience with a database where the DB design skills weren't quite in Art Kagel country. :o) Consequently, in that, more usual, environment, we didn't see anything quite as impressive and decisive as Art found. YAMMV and all that! By all means, test it and if it works, that is really great -- but it isn't necessarily a panacea and may require some database design rework. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed sending to informix-list