Re: SQL or Java?

[Quoted] It would. C program >100 times faster then Oracle server, because it use native compiled code.
Rare C program with "Hello world" functionality exceeds processors cash, so boost can be enormouse.

SQL or Java?
Use sqlloader to load data in temporary table. Then make several simple updates in sqlplus or parse data with pl/sql procedure.

> I think that really depends upon whether relational lookups are necessary
for
> the "cleansing" process. If they are, I seriously doubt that the C/C++
> implementation using only plain text files would be nearly as fast
Oracle...
> at least, I would expect not.

> >as the PL/SQL equivalent. However I also very much doubt that all things
are
> >equal so the only really effective benchmarlk would be to write the two
> >systems and compare them directly.
>
> Not the most efficient solution, but if you have the time to burn....
Received on Thu Jan 17 2002 - 14:43:13 CET