Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Retrieve

2 posts in Appeon (partner product) Last posting was on 2004-07-25 10:39:33.0Z
Herbert Posted on 2004-07-23 23:36:47.0Z
Sender: 269f.4101a185.1804289383@sybase.com
From: Herbert
Newsgroups: sybase.public.appeon
Subject: Retrieve
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4101a208.26a1.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 23 Jul 2004 16:40:56 -0700, 10.22.241.42
Lines: 6
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 Jul 2004 16:29:53 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 23 Jul 2004 16:36:47 -0700
X-Trace: forums-1-dub 1090625807 10.22.108.75 (23 Jul 2004 16:36:47 -0700)
X-Original-Trace: 23 Jul 2004 16:36:47 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:344
Article PK: 20701

how can i get Rows as needed, in appeon, because the appeon
retrieve all the record and i have application that is too
slowly, i am sure that if retreive Rows as needed, that
would be fast.

Thanks


julie.jiang@appeon.net Posted on 2004-07-25 10:39:33.0Z
From: "julie.jiang@appeon.net" <julie.jiang@appeon.net>
Newsgroups: sybase.public.appeon
Organization: 61.144.207.174
References: <4101a208.26a1.1681692777@sybase.com>
X-Newsreader: AspNNTP 1.50 (Takeshi Eto)
Subject: Re: Retrieve
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: web110.discountasp.net
X-Original-NNTP-Posting-Host: web110.discountasp.net
Message-ID: <41038de5$1@forums-1-dub>
Date: 25 Jul 2004 03:39:33 -0700
X-Trace: forums-1-dub 1090751973 64.79.161.40 (25 Jul 2004 03:39:33 -0700)
X-Original-Trace: 25 Jul 2004 03:39:33 -0700, web110.discountasp.net
Lines: 30
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:347
Article PK: 20699

Hi,

You can retrieve rows as needed in several ways:

1) Add a filter to the DataWindow. Before retrieving, you first specify the
filter criteria so to get the rows you need.

2) Using server NVO. You define a datastore and deploy it to the server. The
DataStore is responsible for retrieving all the data (because this retrieval is
directly executed at the server side, it should have c/s performance). The
DataWindow uses RowsCopy to get the needed rows to the client side.

3) (Applicable to Oracle database) Adding the number restriction in the database
by specifying RowNumber.

Hope it helps.

Regards,
Julie Jiang
Appeon Corporation

On 23 Jul 2004 16:36:47 -0700,
in sybase.public.appeon

<Herbert> wrote:
>how can i get Rows as needed, in appeon, because the appeon
>retrieve all the record and i have application that is too
>slowly, i am sure that if retreive Rows as needed, that
>would be fast.
>
>Thanks