#8939 Add index for sudoorder
Closed: fixed 3 years ago by frenaud. Opened 3 years ago by rcritten.

Issue

While testing a reported performance issue with sudorule-mod in ticket https://pagure.io/freeipa/issue/8812 I discovered that sudoorder is not indexed:

                      - Unindexed Filter: (&(sudoorder=49)(&(objectclass=ipaassociation)(objectclass=ipasudorule))) (occurrances 5)
                      - Unindexed Filter: (&(sudoorder=8)(&(objectclass=ipaassociation)(objectclass=ipasudorule))) (occurrances 5)
                      - Unindexed Filter: (&(sudoorder=22)(&(objectclass=ipaassociation)(objectclass=ipasudorule))) (occurrances 5)
                      - Unindexed Filter: (&(sudoorder=79)(&(objectclass=ipaassociation)(objectclass=ipasudorule))) (occurrances 5)
                      - Unindexed Filter: (&(sudoorder=1)(&(objectclass=ipaassociation)(objectclass=ipasudorule))) (occurrances 6)

The reproducer from the other ticket:

for i in {1..5}; do time=$(sh /tmp/test.sh 100 2>&1 > /dev/null);echo $time|cut -d " " -f2; done


See the other ticket for test.sh.

master:

ipa-4-9:

Metadata Update from @frenaud:
- Issue close_status updated to: fixed
- Issue status updated to: Closed (was: Open)

3 years ago

Log in to comment on this ticket.

Metadata