Author Topic: OnDemand - Additional Indices  (Read 169 times)

BHUMENY

  • Newbie
  • *
  • Posts: 20
    • View Profile
OnDemand - Additional Indices
« on: March 22, 2017, 02:55:30 PM »
We are looking for ways to improve the response times of the ARSDOC command.
None of the tables are particularly large, the biggest is only 2.2M rows.  But our measured response times when querying a Folder are 1.2 to 2 seconds.

In the Database section of System I Navigator and IBM Navigator for I, you can look at an Advised Indexes report for the OnDemand tables.  It suggests the creation of additional indexes based on certain key fields.  Is this advisable?

You can also automatically create the indexes right from there but doing so could cause some issues down the road.  First, the names generated are very goofy so by default it’s hard to track down what they are.  Secondly, there are source control issues and locks placed on the underlying tables.  If we were to upgrade OnDemand at any point, those files wouldn’t be able to be manipulated unless all the indexes were deleted first.

If you have any other suggestions for improving the performance, we would be happy to hear them.

Thanks in advance.
Bill

run8

  • Newbie
  • *
  • Posts: 13
    • View Profile
Re: OnDemand - Additional Indices
« Reply #1 on: March 22, 2017, 07:49:05 PM »
We are looking for ways to improve the response times of the ARSDOC command.
None of the tables are particularly large, the biggest is only 2.2M rows.  But our measured response times when querying a Folder are 1.2 to 2 seconds.

Check your application groups to ensure you only index fields that you really need to. Alternatively you might not have the fields you really need set to index in the app group definition....look in the help documentation about using index vs. filter. These values can be updated in an existing application group.

...John Reay
Run 8 Systems Inc.
Toronto
...John Reay
Run 8 Systems Inc.
Toronto

BHUMENY

  • Newbie
  • *
  • Posts: 20
    • View Profile
Re: OnDemand - Additional Indices
« Reply #2 on: March 28, 2017, 08:24:18 AM »
John:
Thanks for your response.
I checked our Application Group settings and although we have 8 fields defined, only 3 are defined as Type Index.  The reset are defined as Filter.

Any other suggestions?

Thanks
Bill

run8

  • Newbie
  • *
  • Posts: 13
    • View Profile
Re: OnDemand - Additional Indices
« Reply #3 on: March 28, 2017, 09:36:47 AM »
Any other suggestions?

It's not clear from your question whether the hit-list takes up to 2 seconds to appear or the actual document.
...John Reay
Run 8 Systems Inc.
Toronto

ewirtz

  • Full Member
  • ***
  • Posts: 133
    • View Profile
Re: OnDemand - Additional Indices
« Reply #4 on: March 28, 2017, 10:36:34 PM »
Hi Bill,
you have to decide / check which searches shall be supported. p.e. you can see the real searches looking for message 226 (if activated). These searches have to be supported with indexes. Sometimes it helps to use compound indexes not only one field. It's a regular task of database optimizing.

regards

Egon