Skip to Content
0
Former Member
Jun 23, 2008 at 08:46 PM

Behaviour of Web Intelligence when Universe imposed limits are reached

85 Views

I am trying to understand exactly what is meant by the following extracts from the Universe Designer guide. Any calrification much appreciated.

"Limit size of result set to a specified value

The number of rows that are returned in a query are limited to the number that you specify. This limits the number of rows returned to Web Intelligence, but does not restrict the RDBMS from processing all rows in the query. It only limits the number once the RDBMS has started to send rows."

Q1This seems to imply that the database returns the result set in batches, and that as soon as Web I has received sufficient batches to exceed the row limit, it won't accept any more?

Q2 Presumably this will terminate the database processing for that query?

Q3 What happens to the data that has been returned. Is the user notified that the result set is imcomplete?

"Limit execution time to a specified value

Query execution time is limited to the number of minutes that you specify. This limits the time that data is sent to Web Intelligence, but does not stop the process on the database."

Q1 So if limit is set to 2 mins, and query takes 3 mins to return very few rows, then query cannot be interrupted?

Q2 But if database is returning a lot of rows (in batches) then as soon as Web I has received sufficient batches to exceed the time limit, it won't accept any more?

Q2 Presumably this will terminate the database processing for that query?

Q3 What happens to the data that has been returned. Is the user notified that the result set is imcomplete?