CSW harvester / Performance improvements

[josegar74]

• Increase GetRecords max records parameter to 100
• Use GetRecords with ElementSetName FULL to retrieve the full xml and avoid individual GetRecordById requests

Includes Sonarlint improvements.

Fixes #7995

Checklist

• [X] I have read the contribution guidelines
• [X] Pull request provided for main branch, backports managed with label
• [X] Good housekeeping of code, cleaning up comments, tests, and documentation
• [X] Clean commit history broken into understandable chucks, avoiding big commits with hundreds of files, cautious of reformatting and whitespace changes
• [X] Clean commit messages, longer verbose messages are encouraged
• [ ] API Changes are identified in commit messages
• [ ] Testing provided for features or enhancements using automatic tests
• [ ] User documentation provided for new features or enhancements in manual
• [ ] Build documentation provided for development instructions in README.md files
• [ ] Library management using pom.xml dependency management. Update build documentation with intended library use and library tutorials or documentation