You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Description
Strapi has not a lot of ways to add documents in batches. Most ways to achieve entry addition is one by one. While it is not a problem with a small number of document addition, if a user add's thousands of document at the time the web-server starts to reject new webserver calls, or abort new additions to its own database.
Error: aborted
262: aborted
Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?
Another issue is that Meilisearch does not like at all to have small batches. Meilisearch is more performant with one addition of 100Mo of document than it is with 10000 additions of 1 document.
To avoid this, we should create a debounce system or a throttle system that avoid an overload of calls to meilisearch.
The text was updated successfully, but these errors were encountered:
Description
Strapi has not a lot of ways to add documents in batches. Most ways to achieve entry addition is one by one. While it is not a problem with a small number of document addition, if a user add's thousands of document at the time the web-server starts to reject new webserver calls, or abort new additions to its own database.
Another issue is that Meilisearch does not like at all to have small batches. Meilisearch is more performant with one addition of 100Mo of document than it is with 10000 additions of 1 document.
To avoid this, we should create a debounce system or a throttle system that avoid an overload of calls to meilisearch.
The text was updated successfully, but these errors were encountered: