Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Users List UI slow 10 seconds if there are 100,000 users in the sql resolver. #1901

Closed
yangboyd opened this issue Oct 24, 2019 · 2 comments

Comments

@yangboyd
Copy link

@yangboyd yangboyd commented Oct 24, 2019

Maybe this is a feature request.
The pagination parameter is not transferred from web ui to the privacyIDEA server.
So it causes the UI slowly.

This feature maybe sql resolver only.
Other resolvers may not support offset/limit search parameters.

@cornelinux

This comment has been minimized.

Copy link
Member

@cornelinux cornelinux commented Oct 24, 2019

privacyIDEA explicitly adheres to the concept of I-do-what-you-configured. And you probably need to change your settings.

Reduce the parameter "Sizelimit" in your SQL Resolver! Since you probably do not want to browse through a list with 6666 pages!

You will always first search for a user with certain pattern (and being it the first two characters) and then browse through a list with one or two pages.

Are you really running privacyIDEA with 100K users? Or did you forget the "where" statement.

If you think the SQL-Resolver should be changed, please propose some more details or even a pull request.
(Otherwise this issue is about to be closed)

@cornelinux

This comment has been minimized.

Copy link
Member

@cornelinux cornelinux commented Nov 1, 2019

no details received, so I am closing this.

@cornelinux cornelinux closed this Nov 1, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants
You can’t perform that action at this time.