Slow search results (SOAP)

Hi,

(not sure if this is the right place for such a question, maybe move this to "DEV: GroupWise Web Service (SOAP)"?!)

It's about our email archive, which has a slow perfomance. We tracked that down to a simple search in groupwise.
In Detail: The application connects to the groupwise soap port via https as a trusted key app.
Log in to a user and descending into folders. In every folder it queries groupwise with a search for mails between a specific time frame (e.g. items where older than one year).
Here is an example of the filter: Filter[(
  • In article <bendeichp.7c0ey1@no-mx.forums.microfocus.com>, Bendeichp
    wrote:
    > (not sure if this is the right place for such a question, maybe move
    > this to "DEV: GroupWise Web Service (SOAP)"?!)


    That might be the best bet.
    A few things I would check first
    - The POA logs, especially if you set them to at least verbose, and see
    what they show when you do a query. The answer might be right there.
    - What is CPU and RAM usage when those queries are run? Do they push it
    harder than the normal client based queries? Perhaps you are getting
    close to that threshold of needing some more of those resources.
    - Packet capture the query to see if there is any extra back and forth
    happening or some timeouts.

    Further question I would have for the developer types, does the SOAP
    accessed queries make use of the GroupWise indexes?


    Andy of
    http://KonecnyConsulting.ca in Toronto
    Knowledge Partner
    http://forums.novell.com/member.php/75037-konecnya
    If you find a post helpful and are logged in the Web interface, please
    show your appreciation by clicking on the star below. Thanks!

  • Hi Andy
    - The POA logs, especially if you set them to at least verbose, and see
    what they show when you do a query. The answer might be right there.

    With verbose log level on, this is all I can see:
    00:09:44 6AEE SOAP command:[loginRequest] requested from 127.0.0.1 User session(mxxxg)

    - What is CPU and RAM usage when those queries are run? Do they push it
    harder than the normal client based queries? Perhaps you are getting
    close to that threshold of needing some more of those resources.


    While investigating another case here, I noticed high CPU utilization in the same POA. But only during working time.The utilization is low during night while the archive appliance is running (and SOAP requests are slow)... For now I would say high load and the slow searches are not really related...

    Thanks,
    Pascal
  • Hi Pascal,

    you can see more details (or almost all) regarding soap if you enable soap logging - just go to the log settings in the web console of the poa and tick the respective things under "SOAP Logging Options" - be aware that some of the soap logging is in a separate log file (not the poa log).

    Another point we recently discovered is, that in 2014 R2 for some reason the Proxy Calendars are traversed to the other mailbox for some archiving tools. Even if the archive tool just says 'all mail messages' the requests over SOAP trigger the POA to read the content of the proxy calendar, even on remote servers. Only workaround so far (and enough for our case) was to exclude everything below Calendar.
    Do you have proxy calendars in the user which you read from via SOAP? If yes, try to remove them and check if the search time stays the same.

    kind regards
    Mathias