Re: Which is better in performe queries to Oracle ,Java or C, PERFORMANCE question

What will be more important is whether you use host variables in your 20 x 10^6 queries. Also how many parses etc. Ideally you should open the cursor once with host variables, execute, fetch, change the bind variables, rebind reexecute, fetch etc. The next thing would be use array fetching. And of course write good queries.

The fastest method is going to be using the OCI interface in C. (assuming things are written effeciently in all languages.) Then pro C then Java (not the thin client driver).

But no matter what language you write in the over whelming factor for repeated etc. queries (I'm assuming using bind variables you really only have a much smaller number of queries eg "select name, dept from employee where employeeid=:hv_employeeid;" is really 1 query with a lot of possibilites. hv_employeeid being the host variable.)

Clearly Java has an advantage in terms of number of platforms you can port the code unaltered. What language you write in may depend more on what your developers are more happy writing in and how well they do it. (If they are happier or comfortable writing in Java then they will probably do a better job in Java.)

Jim

"tomer" <tomerav_at_amdocs.com> wrote in message news:28015d46.0111280956.900af2d_at_posting.google.com...
> Hi!
> we have to make process that has to make 20,000,000 (20 Millon) queries .
> And we can do it in Java or C (with pro c ,ofcourse)
> Do you know which will do it faster ?
> Do you know disadvantage to one of the these languages in this process ?
>
> Thanks
Received on Wed Nov 28 2001 - 19:27:05 CET