[PERF] argilla server: Reduce general transaction time

[frascuchon]

Description

• Remove unnecessary extra SAVEPOINTS
• Move out of the commit all search index operations
• the refresh parameter for es can be set to wait_for instead of true since index operations are out of transactions. This will help with the es performance.

Type of change

• Bug fix (non-breaking change which fixes an issue)
• New feature (non-breaking change which adds functionality)
• Breaking change (fix or feature that would cause existing functionality to not work as expected)
• Refactor (change restructuring the codebase without changing functionality)
• Improvement (change adding some improvement to an existing functionality)
• Documentation update

How Has This Been Tested

Checklist

• I added relevant documentation
• I followed the style guidelines of this project
• I did a self-review of my code
• I made corresponding changes to the documentation
• I confirm My changes generate no new warnings
• I have added tests that prove my fix is effective or that my feature works
• I have added relevant notes to the CHANGELOG.md file (See https://keepachangelog.com/)

[codecov[bot]]

Codecov Report

Attention: Patch coverage is 91.46341% with 7 lines in your changes missing coverage. Please review.

Project coverage is 91.24%. Comparing base (66454e8) to head (dc7cb1a). Report is 1 commits behind head on develop.

Files with missing lines	Patch %	Lines
...lla-server/src/argilla_server/contexts/accounts.py	42.85%	4 Missing :warning:
...ver/src/argilla_server/search_engine/opensearch.py	0.00%	2 Missing :warning:
.../src/argilla_server/search_engine/elasticsearch.py	66.66%	1 Missing :warning:

Additional details and impacted files

```diff @@ Coverage Diff @@ ## develop #5609 +/- ## =========================================== + Coverage 91.21% 91.24% +0.03% =========================================== Files 145 145 Lines 6065 6032 -33 =========================================== - Hits 5532 5504 -28 + Misses 533 528 -5 ``` | [Flag](https://app.codecov.io/gh/argilla-io/argilla/pull/5609/flags?src=pr&el=flags&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=argilla-io) | Coverage Δ | | |---|---|---| | [argilla-server](https://app.codecov.io/gh/argilla-io/argilla/pull/5609/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=argilla-io) | `91.24% <91.46%> (+0.03%)` | :arrow_up: | Flags with carried forward coverage won't be shown. [Click here](https://docs.codecov.io/docs/carryforward-flags?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=argilla-io#carryforward-flags-in-the-pull-request-comment) to find out more.

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.