Poor performance Web vs Bex

[Former Member]

Hello all,

we have this strange behavior that a query runs faster in Bex than it does in Web. For some reason these queries run in 5 seconds when started in Bex and they cause a time-out when the are started in web.

Does any of you have a clue about this strange behavior?

Kind regards,

Harald

[edwin_harpino · Accepted solution]

hi Harald,

take a look oss note 567746-Composite note BW 3.x performance: Query & Web applications

764394-Guide for performance improvement of Web Applications

...

IV. Web applications

Performance analysis of Web applications: Tools for analyzing Web applications are available on the BW Performance page on the SAP Service Marketplace (service.sap.com/bw -> Performance).

Note 560255: Document display performance with large structures (up to BW 3.0B Support Package 7)

Note 568844: Very long HTML load times (compared with Analyzer) (up to BW 3.0B Support Package 7)

Note 764394: Guide for performance improvement of Web

V. Compression of Web applications and browser caching

Note 550669: Compressed transfer of BW Web Applications

Note 561792: Client-sided caching of image/gif files

Note 553084: Web application is slow, icons are displayed with delay (up to BW 3.0B Support Package 6)

Note 542576: HTTP compression is not active (up to kernel 6.20 patch level 251)