Restricting # of records processed

From: Baylis, John <JBaylis_at_mail.canfor.ca>
Date: Fri, 17 Nov 2000 12:09:18 -0800
Message-Id: <10683.122415@fatcity.com>

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2652.35">
<TITLE>Restricting # of records processed</TITLE>
</HEAD>
<BODY>

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
Received on Fri Nov 17 2000 - 14:09:18 CST