Database Performance

[Former Member]

Hi All,

Listing 35k line items (via transaction code SQ01), system required approximately 21 secs to load, is that acceptable? How is the performance of a SAP System being measured? Is there any guideline?

Thanks a lot!

[Former Member · Accepted solution]

Hello

How is the performance of a SAP System being measured?

have a look and search relevant docs in help.sap.com

Regards

Vinod

[former_member204746]

SQ01 is a resource hog, so getting info from it is normally slow. code generated from SQ01 is usually not efficient.

so, if you complain about SQ01 performance and you plan to use a query repeatedly, go write an ABAP program for your need and make it efficient by using proper indexes.