Re: Tough c++/Oracle Question???

I am using this value (192-bit one-way unique hash value) as the primary key. I will be working with over a billion records each day so I want it to be as fast as possible. Therefore, I did not use 3 numeric fields so I concatenate the array to be able to input it into the single numeric field but I cannot figure out how to get it back out :o(

"Bradley Crockett" <bcrockett_at_altavista.net> wrote in message news:ElMv7.53823$L8.14949440_at_news2.rdc1.bc.home.com...
> In article <9po2bi$r1$1_at_bob.news.rcn.net>, aa_at_bb.net says...
> >
> >1. I have a table in Oracle that contains a NUMERIC field
> >2. I INSERT the variable unsigned long long llValue[3] into
> > the numeric field by INSERT ....
> > Values(llValue[0] | llValue[1] | llValue[2]);
>
> I don't understand what you've done here. Why do you have a pipestem
 between
> each array element? Are you trying to concatenate or is that a delimiter?
>
Received on Sun Oct 07 2001 - 01:39:32 CEST