Hello,
I'm using a BSP application with a HTMLB TABLEVIEW to display R/3 equipment data in the browser. The table contains of 11 columns. Depending on selection criteria, the number of rows is up to 2000.
I saved one of these lists; the size of the generated HTML file is 2 - 4 MB. After data is selected in the onInitialization event, it takes about 10 seconds for the browser to render the table. I doubt this can be accelerated, although users would be glad about it.
However, the main problem is the delay if you click inside the BSP application, e.g. if you click on the button to start a new selection or if you want to use the filter functionality of the table (input fields on top of each column). It lasts up to 20 secs until the click of the mouse button affects the application. It doesn't depend on what function you want to trigger, e.g. go to next page since we've already limited the number of rows to be displayed.
I've set the number of rows to be displayed on one page to 50. Then it works fine. However, imagine a result list of 2000 entries; you'd receive 40 pages you have to go through. This is not acceptible for the users.
Here are some snippets of the page's coding:
-
<htmlb:content design="design2002+design2003" >
<htmlb:document disableBackspaceNavigation="TRUE" >
<htmlb:tableView id = "table01"
table = "<%= mli_data %>"
width = "620"
visibleRowCount = "<%= lv_visible_rows %>"
filter = "server"
sort = "server" >
<htmlb:tableViewColumn columnName = "vkorg"
fixedColumn = "false"
verticalAlignment = "middle"
horizontalAlignment = "right"
edit = "false"
sort = "true" />
-
I tried to change the design of the CONTENT-tag, however, "Design 2003" is required for the F4 value helps.
I turned on compression, but it hadn't any effect.
I've searched the SDN forum and SAP notes. Several issues in the SDN forum were related to BSP performance, however, no one did contain the "click latency" I've described above.
Any ideas how to improve performance? We're currently on SAP_BASIS 620 SAPKB62046.
Thanks & regards
Wolfgang