Message-Id: <10683.122415@fatcity.com> From: "Baylis, John" Date: Fri, 17 Nov 2000 12:09:18 -0800 Subject: Restricting # of records processed This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C050D2.442A9710 Content-Type: text/plain We have an application that allows users to enter various selection criteria for a query. Is there any way to programatically stop processing the query after x numbers of records read in order to tell the user his selection criteria is not restrictive enough? In other words, I may have to read more than 1,000,000 records before it matches my selection. I would like to say to the user 'You have read 100,000 rows so far, ... please be more selective'. I do not think using rownum will work since rownum is assigned to rows that meet the selection criteria not to all the rows read. I do not want to use a user profile with logical_reads_per_session specified since I do not want the session to be terminated after reaching that limit. Is there another way? John Baylis DBA / Systems Administrator Canadian Forest Products Ltd. Vancouver B.C. Canada ------_=_NextPart_001_01C050D2.442A9710 Content-Type: text/html Content-Transfer-Encoding: quoted-printable Restricting # of records processed

We have an = application that allows users to enter various selection criteria for a = query.

Is there any way to = programatically stop processing the query after x numbers of records = read in order to tell the user his selection criteria is not = restrictive enough?

In other words, I = may have to read more than 1,000,000 records before it matches my = selection. I would like to say to the user 'You have read 100,000 rows = so far, ... please be more selective'.

I do not think = using  rownum will work since rownum is assigned to rows that meet = the selection criteria not to all the rows read.

I do not want to use = a user profile with logical_reads_per_session specified since I do not = want the session to be terminated after reaching that limit.

Is there another = way?

John = Baylis
DBA / Systems Administrator
Canadian Forest Products Ltd.
Vancouver B.C. Canada