Technisch Latest content Contact forms Forums Blogs Resources

MassOperations / DatabaseTable Usage

lock
push_pin
done
Beantwoord
3
4

Anyone using the MassOperations API?

In NetServer Core, this is located in SuperOffice.Data.Dialect namespace, SuperOffice.Data.Dialect.MassOperations.

In NetServer web service Agents, it is facilitated by the DatabaseTableAgent endpoint

With the introduction of freetext indexing on udef string fields, this has proven to have a negative impact on MassOperations performance. 

A recent scenario highlighted the impact when performing an Upsert operation, uploading four thousand rows with one or more user-defined fields, went from ca. 4 seconds to 3 minutes.

This performance degragation only occurs when udef string fields are used. Extra fields have no affect.

Question: will this affect your apps or integrations?

Best regards.

 

Tony Yates
15 sep 2023 | 02:55 p.m.

Alles Antwoorden (4)

We use the DatabaseTableAgent a lot, but mostly for inserting into custom tables, which are not indexed. MassOperations for now only when doing a single one time import.

David Hollegien
18 sep 2023 | 08:57 a.m.
Thanks David, does that one-time import include udefs, and if so can we defer a performance fix for a future release?
Tony Yates
18 sep 2023 | 09:06 a.m.
Hi, it could include udefs, it depends per company, this scenario mostly occurs during a migration from OnSite to Online where a customer has created integrations them self (or external parties) which we want to include in SuperOffice directly.

For us this is not a high priority issue/red alert, so a fix in future release is fine (or just do not index on mass operations and make it clear that you need to trigger a free text index regeneration yourself)

David Hollegien
18 sep 2023 | 09:11 a.m.

Hi Tony,

We use the Upsert operation on udefs of type "Short text". Are they also affected?

Véronique Borel
25 sep 2023 | 09:23 a.m.

Reply toevoegen