Skip to Content

Poor query performance when display icon for infoprovider documents

Hi,

We are using BI documents/comments heavily in our web reporting and are suffering from poor query performance. One query could run for several minutes with BI document icons on while without that the result will pop up within 30 seconds.

So how can I improve the query performance, for we really need to use BI documents?

I heard that TREX can help here, but simply couldn't find any documents about that.

Please help.

Regards,

Shady Shen

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2008 at 01:02 PM

    Shen,

    TREX will improves the DB reading by 200 times but the OLAP improvement is less than or equal to 8times the performance so In this case I think BIA will not gives expected results.

    Regards,

    RK

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 05, 2008 at 05:31 PM

    Hi,

    Search and Classification (TREX) is the backend technology that powers SAP NetWeaver Enterprise Search and most other search functionalities in SAP products and solutions. It provides SAP applications with numerous services for searching, classifying, and text-mining in large collections of documents (unstructured data) as well as for searching in and aggregating business objects (structured data). TREX processes documents in a wide variety of formats and in more than 30 languages.

    http://help.sap.com/saphelp_nw2004s/helpdata/en/40/83505303bd5616e10000000a114cbd/frameset.htm

    https://www.sdn.sap.com/irj/sdn/virtualteched07sessions-keyword?rid=/webcontent/uuid/50663e15-9e5f-2a10-8d90-9fc9e0af2722

    Regards.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 06, 2008 at 07:59 AM

    Thanks for your reply.

    But could you be more specific about how TREX can help in our BI document scenario?

    Regards,

    Shady

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2008 at 12:58 PM

    Hi Shen,

    You can try with web Template. It will improve the query performance.

    http://help.sap.com/saphelp_scm2007/helpdata/en/ac/9ec200a2ac2e4d8e5c0eb9146219bb/frameset.htm

    If this reply helps you pls assign points.

    Regards,

    RK

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 07, 2008 at 01:14 PM

    Hi RK,

    Thanks for your reply. Are you referring to BIA?

    I'm afraid it is not relevant here. I think by TREX, it is still the traditional search and classical engine. I had thought by indexing all the BI documents for infoproviders, the display of document icon could be faster somehow. But I am not sure whether and how it works.

    I checked with the BI statistics. Most of time is spent on event 13300 (read BI document) and DB time can be omitted due to the small data volume. So BIA won't help here, I guess.

    Any idea how I reduce the time spent in event 13300? Please advice.

    Thanks and Best Regards,

    Shady

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.