topic Re: Buffer displayed records for ALV Table in Application Development and Automation Discussions

Buffer displayed records for ALV Table

Former Member — Wed, 20 Oct 2010 18:21:34 GMT

Dear Experts,

when showing large tables (whide structures, many records) I'm facing the issue of reloading times, when a user scrolls down the ALV. I guess this relates to rebuffering the records from the AppServer to the GUI. Is there any way on setting up how many records are loaded initially?

Thanks a lot in advance,

Peter

Re: Buffer displayed records for ALV Table

ravi_lanjewar — Thu, 21 Oct 2010 07:32:49 GMT

Hi,

It is ALV display standard functionallity.

Try this.

Go to change layout, Then select display tab, It has many check box, Check the display total lines above the entries.

It will display, Total no. of line are in alv display.

Re: Buffer displayed records for ALV Table

Former Member — Thu, 28 Oct 2010 09:25:53 GMT

Hi,

acutally I don't get this hint. No I've got my sum line at the top of the grid.

But what I wanted to achieve, is that the data is buffered so there's no reloading time when scrolling down in the grid.

Thanks,

Peter

Re: Buffer displayed records for ALV Table

Former Member — Tue, 10 Apr 2012 19:00:19 GMT

Hello Peter,

Were you able to resolve this issue? I'm facing the same problem.

Any hints?

Kind regards!!

Re: Buffer displayed records for ALV Table

yuri_ziryukin — Wed, 11 Apr 2012 08:02:17 GMT

Well, I can only guess, but I think that ALV is clever enough to not pass whole table to the front-end at the moment of first display. As soon as the user scrolls, the ALV control makes a call to the back-end and fetches the data to be shown from the internal table. You can verify if it is the case by checking statistical records.

Re: Buffer displayed records for ALV Table

Former Member — Wed, 11 Apr 2012 10:55:37 GMT

what is the actual problem ... you might thing that it is feature not a bug.

The ALV sends only some records to the frontend and reloads others when they are really needed to be displayed.

What would you like to change?

Maybe your problem is only a bad sort! Try to sort in a way that the most interesting records come with the initial load. Or try to select better in way that your result is smaller. These are simple examples, but maybe it can guide you in the direction to a proper solution.

Siegfried

Re: Buffer displayed records for ALV Table

HermannGahm — Wed, 11 Apr 2012 12:15:49 GMT

Hi Peter,

for questions like this, i think, the underlying reason of the question should be reconsidered. As the others said, ALV works as designed. The question for me is: WHY do you want all records at once on the frontend?

Kind regards,

Hermann