Select Query - Optimized Way

[Former Member]

Hello ABAP Gurus..

I dont have much idea about ABAP side but we have a requirement in our project where we need to fetch huge amount of data from backend and display it on the WebDynpro Java screen. I was going through the paging solution provided by SAP so that we can minimize the Java AS server memory and performance issues.

I was wondering if we can get the selective no of records from tables based on pagesize. What I mean here:

Suppose total no of record that I want to display on the WebDynpor screen is say 10000.

PageSize of my webdynpro table = 100 records

Now Can I write a select query (or is there any other way) to get data from backened table pagewise like at first hit I get records from 1 - 100, second hit I should get records from 101 - 200 , third hit from 201 - 300.. and so on till the lat record?

Is it possible? If yes, how can I acheive this?

-Abhinav

[Former Member]

Yes - check the PACKAGE SIZE addition to the SELECT statement.

You should also search the forum using this criterion and you will get a lot of information.

Rob

[Abhinav_Sharma1]

Hey Rob ,

Thanks for quick response.

However, I have a doubt here.

Suppose my PACKAGE SIZE is 100 and I fetch first 100 records in first RFC call, then how do i fetch records from 101 - 200 in the subsequent RFC call?

Also, I guess SELECT .. ENDSELECT has its own performance problems

- Abhinav

[Former Member]

The next SELECT will get the next group of records. As I said, see the help. It should answer most of your questions.

Rob