Jul
04
2024
Postgres DB issue with more than 1000 partner
If you are using the Postgres DB and have more than 1000 partner 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 tables. On our test systems the data load for about 1500 partners from the database with all their PMode configuration is about 10 times faster now. The performance change depends on the number of partners and (like always) 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>