> On 1 Nov 2024, at 08:51, tdarby--- via 389-users > <[email protected]> wrote: > > We have an application that needs to query for and return thousands of > entries with modifyTimeStamp greater than a given time. This is turning out > to be too slow for this app and so I'm wondering if there's any way to speed > this up other than throwing more CPU at it. >
Is modifyTimestamp indexed? Have you raised your idlscanlistlimit to 999999999? Sounds like you have a full table scan going on. The above two changes will fix it. -- Sincerely, William Brown Senior Software Engineer, Identity and Access Management SUSE Labs, Australia
-- _______________________________________________ 389-users mailing list -- [email protected] To unsubscribe send an email to [email protected] Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/[email protected] Do not reply to spam, report it: https://pagure.io/fedora-infrastructure/new_issue
