Jul
08
2024
Postgres DB issue with huge amount of partners
If you are using the Postgres DB and have a huge amount partners and transactions in your system this is an important update for you. If you are using the internal HSQL DB this update will not change the behavior of your system.
<ul>
<li>Postgres DB does not automatically create an index for secondary keys - they have been added now with this update to relevant database tables. The performance change depends on the number of partners, your system and the infrastructure. Because most REST API operations depend on partner access this will also speed up your REST access time.</li>
</ul>