topic Re: Select Query - Optimized Way in Application Development and Automation Discussions

Select Query - Optimized Way

Former Member — Thu, 19 Feb 2009 21:38:43 GMT

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

Re: Select Query - Optimized Way

Former Member — Thu, 19 Feb 2009 21:49:22 GMT

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

Re: Select Query - Optimized Way

Abhinav_Sharma1 — Thu, 19 Feb 2009 22:04:48 GMT

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

Re: Select Query - Optimized Way

Former Member — Thu, 19 Feb 2009 22:09:24 GMT

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

Rob