Parallel Processing of multiple queries in a report

Farhan Jaffery

It has been a while since I saw a post on this and can't find a definite answer via search:

Does BOE XI 3.1 have a mechanism to allow multiple queries within a single WebI report to be submitted to the database in parallel rather then sequentially?

Thanks.

BO_TN · Principal Member Joined: 30 Jul 2008 Posts: 216

I would be interested in finding this as well.

My initial thought is this is probably not possible. Just because the tool allows users to make queries using objects from another query. This would mean the first query has to be run and complete first before the second kicks in.

I could be wrong of course.

Jansi

As far as I know, we can't control the execution of queries. When we use 'Query on Query' feature, then the order of execution changes. The parent query executes first.

sdeshpan

Marek Chladny · Forum Devotee Joined: 27 Nov 2003 Posts: 10327

netzbewohner · Forum Member Joined: 14 Apr 2010 Posts: 1

Hi guys, I would like to bring that topic up again.

I am also looking for a way to have the multiple queries executed simultaneously in WebI on my BOE XI 3.1 server. Monitoring the behavior, the queries are exectuted one after another (sequentially).

Maybe there is some undocumented setting somewhere? This would greatly improve performance if all queries are run on a Teradata DB backend!

Dave Rathbun

From some initial discussions, the new universe format for XI 4 might offer some help in this area. The Federator product is supposed to be embedded within the universe, and if you scan multiple sources (for example Oracle and Teradata at the same time) those are fired out in parallel. It would be interesting to see if we could trick it to fire multiple queries against the same source in parallel.

All of this is pure speculation since XI 4 is not out yet and I have not even been able to see a beta product either.

For 3.1 and earlier, however, sequential seems to be the only method supported.