Hi Daniel,
What database are you running? We have a SQL Server database, where
the server is shared between several systems. We don't experience much load on the
database though, so we have not yet suspected the database to be the problem.
We are using Oracle.
One interesting finding is that when we try to run the import locally
on our laptops, we don't have any performance problems. In that case, we use the H2
database that comes with Keycloak.
One thing you could try is to give Keycloak more memory (Java's Xmx
parameter). Other than that I don't really know what to suggest.
Best regards,
Marian