Home

Results 1 to 2 of 2

Thread: Slow search results (SOAP)

Hybrid View

  1. #1
    Join Date
    Aug 2009
    Location
    Germany
    Posts
    309

    Slow search results (SOAP)

    Hi,

    posted in the GW Agent forums, but maby better to put it also in here:
    Slow-search-results (SOAP)

    Thanks in advance,
    Pascal
    "Have you tried turn it off and on again?"

  2. #2
    Preston Stephenson NNTP User

    Re: Slow search results (SOAP)

    There can be many factors as to why the searches are slow.

    In the GWClient, the code searches on DRN's (sids).
    This is the record number of the item in the database.
    In this case, the code doesn't have to read the actual database files.
    The GWClient gets back the DRN's and only reads the item data if it has to.

    WebAccess does a similar thing using SOAP. It gets back the sids.
    Then reads the items if it needs to.

    If you just ask for the id (sid) of items, the query should be pretty fast.
    If you ask for the user's item ("default"), it will slow the query.
    If you ask for attachments (message body, attachments, recipient lists), it
    will slow down the query significantly.
    If you ash for recipient status, it will slow down the query exponentially.

    One thing that might speed up the search is to use startDate instead of
    created.
    All items have a startDate element, it is just not exposed in mail or phone
    messages.
    (In GW14R2, the <begins> element (which is the same internal field) is
    exposed.)

    The startDate field is in the index. The query can be modified to search the
    index, then filter on the items returned from the index.

    As is now stands, each query will have to read all items in the user's
    database for each query.

    Another way to improve the throughput is to use events.
    You can get notified when things happen.
    You can keep tract of the changes and just process the changes.
    This is significantly faster than dredging for changes.

    Let me know if you need further help.

    Preston


    >>>


    > Hi,
    >
    > posted in the GW Agent forums, but maby better to put it also in here:
    > 'Slow‑search‑results (SOAP)'
    >

    (https://forums.novell.com/showthread...ch‑results
    %28SOAP
    > %29)
    >
    > Thanks in advance,
    > Pascal


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •