Designer Question

building semantic layer
1

All.

I am using BO5 with Oracle8.

In the Designer module in the parameters > controls panel there is a RESULT LIMIT setting. This is probably a daft question but does that mean the query only runs against the first 5000 (assuming it is set to 5000) rows it encounters or returns the first 5000 rows of the query result ?

I shall expound.

If I have a table called TABLE A containing 10000 rows and I do a select on it with a RESULT LIMIT of 5000, does that mean it will only apply the select query to the first 5000 rows and return th results, OR, run the select query in it’s entirety and return the first 5000 rows of the query result.

(I know in this case the answers would probably be the same but this is a very simplistic example).

Thank you.

Darren.

Listserv Archives (BOB member since 2002-06-25)

2

My experience (assuming the RESULT LIMIT is set to 5000) has been that it returns the first 5000 rows that satisfy the query (even if it has to query 100000 rows to find these 5000).

George Baranowski
QuadraMed

Listserv Archives (BOB member since 2002-06-25)

3

George,
you are right. This is exactly what it does.

Walter

“Baranowski, George” schrieb:

My experience (assuming the RESULT LIMIT is set to 5000) has been that it returns the first 5000 rows that satisfy the query (even if it has to query 100000 rows to find these 5000).

–
Walter Muellner
Delphi Software GmbH / Austria
w.muellner@delphi.at, Tel. +43-1-8151456, http://www.delphi.at

Listserv Archives (BOB member since 2002-06-25)