ALV or Tables footer and Pagination as of 701and performance

[Former Member]

Hello Experts,

I ended up reading the thread hereafter because I could not find a way to display footer for pagination in my table view :

I am very suprised by the answer of Thomas Jung, who states that the feature of pagination is not more available as af version 7.01.

My original problem is about performances. If I display 2000 entries in a table, any kind of scrolling has a very very bad result in terms of performance. I was counting on the pagination to improve this...

So, my first question is to confirm the non-availability of pagination as of version 7.01, the second question is how to handle the display with good performances of a large amount of lines in a table (knowing that I have the same requirement for both table and ALV ).

Thanks in advance for your answer,

Guillaume

[thomas_jung · Accepted solution]

Yes the paginator is gone in 7.01 and Lightspeed. There is a recent OSS note that made it possible to use the paginator on 7.01, but only if you disable lightspeed for your application. This is a rather extreme choice as Lightspeed makes significant performance improvements possible. It is also a requirement for using any of the new UI elements. So if you choose the paginator you really criple the functionality of your application.

It is odd that you say you have performance problems with the scrollbar. How many rows do you have visible? The total number of rows shouldn't matter to performance and certainly 2000 rows won't slow anything down. I've got a video on SDN where I used 1 million and 10 million rows in a WDA table and had no performance problems with the scrolling at all.

[Former Member · Accepted solution]

Thank you very much for your answer, Thomas.

I tried again today, and indeed, I have no more problem of performance with scrolling about 2500 lines, regarding the table view. I just recall we had system issues yesterday that might have had this impact.

However, scroling 2500 entries in the ALV is still very slow ... Have you already tested this ? If so, have a link to a demo ?

Thanks in advance, again,

Guilllaume

[thomas_jung · Accepted solution]

There is really no reason why scrolling within the table or the ALV would take any difference in time. I've certainly done ALVs with far more than 2500 rows and not had performance problems. Perhaps you should do a runtime trace and see where the time is actually being spent.

[Former Member · Accepted solution]

OK, I did the trace, and I don't get why, but all the lines of my ALV get calculated again... as if it was refreshing, but i did not code any refresh of the ALV...

I need to investigate more, but if you have any tips about that, don't hesitate.

Guillaume

[Former Member · Accepted solution]

My mistake, I was not handling properly the WDDOMODIFYVIEW method... which is triggered on scrolling.

Sorry about that, thanks for the previous answers.

Guillaume

[Former Member]

Hi,

As per the above link, if there is a scrollbar set then you can now the record number right...

If you donot want this way...

I guess...in the ALV footer or table footer should should have some custom label that displays the record count calculated by you..

Also refer tho this thread ..

Edited by: Lekha on Dec 11, 2009 5:56 PM