Re: Collective Time of executing multiple queries in parallel and sequential

Difficult to answer. Depends. Is there enough IO and CPU to handle multiple connections? If there were a million connections and each one issued a query at the same time then you would backup on the CPU and IO limits. In that case it might be that the overhead of managing all those would overwhelm any advantage. I think that yes, multiple connections up to a point will be faster. More CPU and faster IO will help also make sure you use bind variables. That alone will help greatly (lowers CPU usage).

One thing to consider is that each connection will be a separate transaction and thus each will have their own view of the database. The upshot of that is that you may get some odd results if you combine things from different connections. Which might or might not be acceptable. Jim

"mdali" <mdali_germany_at_hotmail.com> wrote in message news:52e58772.0111210822.7b60c0a8_at_posting.google.com...
> Hi All,
>
> Pls. do forgive me if I am posting in the wrong forum. Actually I am
> working on an application which requires to perform a large number of
> SELECT SQL queries on oracle server. The number of queries to be
> performed is in thousands. I want to know if I execute multiple
> queries on an oracle server using diffrent connections. Is this
> strategy faster than executing the queries one by one sequentially.
> Does practically oracle which is installed with normal options
> provides some more speed in case of multiple connections. Or it still
> handles all the queries one by one. And the collective time of
> exceuting queries from multiple connections comes equal to that of
> executing the queries one by one.
>
> Regards
> Muhammad Ali
Received on Wed Nov 21 2001 - 10:59:37 CST