Equality should be the index you need. It implies ordering depending on the type.
> On 2 Nov 2024, at 03:26, Darby, Tim - (tdarby) via 389-users > <389-users@lists.fedoraproject.org> wrote: > > Thanks! Which index should I put on modifyTimestamp? > > > Tim DarbyFrom: William Brown via 389-users <389-users@lists.fedoraproject.org> > Sent: Thursday, October 31, 2024 16:52 > To: 389-users@lists.fedoraproject.org <389-users@lists.fedoraproject.org> > Cc: Darby, Tim - (tdarby) <tda...@arizona.edu>; William Brown <wbr...@suse.de> > Subject: [EXT] [389-users] Re: Using modifyTimeStamp in queries > External Email > > > >> On 1 Nov 2024, at 08:51, tdarby--- via 389-users >> <389-users@lists.fedoraproject.org> 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 -- 389-users@lists.fedoraproject.org > To unsubscribe send an email to 389-users-le...@lists.fedoraproject.org > 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/389-users@lists.fedoraproject.org > Do not reply to spam, report it: > https://pagure.io/fedora-infrastructure/new_issue -- Sincerely, William Brown Senior Software Engineer, Identity and Access Management SUSE Labs, Australia -- _______________________________________________ 389-users mailing list -- 389-users@lists.fedoraproject.org To unsubscribe send an email to 389-users-le...@lists.fedoraproject.org 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/389-users@lists.fedoraproject.org Do not reply to spam, report it: https://pagure.io/fedora-infrastructure/new_issue
