Merge command accessible via YottaDB's API interface?

[Rob Tweed]

We use the YottaDB callin API interface for our mg-dbx-napi interface package.

The callin interface provides native access to all the YottaDB database commands we need/use except for one command: MERGE

Not sure why this is, and of course there are higher-level ways to emulate a merge, but it would be nice if the much higher-performant system-level-implemented MERGE was accessible via the API.

Is there any plan for this to be made possible, and if not, can we put in a request for it please?

Not a show-stopper for us, but it would be a very nice to have sometime.

[Sam Habiel]

Rob,

The issue https://gitlab.com/YottaDB/DB/YDB/-/issues/204 was created 5 years ago. We never prioritized it as important as no customers said they wanted it.

If Chris M wants to code it, we will welcome the contribution. But keep in mind that any changes to YottaDB take a lot of effort... so it won't be a one day job. More like a month or more.

Bhaskar may have some history on who actually requested the original issue.

--Sam

--
You received this message because you are subscribed to the Google Groups "Everything MUMPS" group.
To unsubscribe from this group and stop receiving emails from it, send an email to everythingmum...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/everythingmumps/cbaa022f-654f-4faa-8e9b-e836b386eaa7n%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[K.S. Bhaskar]

I don't remember who requested it originally, so I'll blame my evil twin brother.

We don't have the bandwidth to implement MERGE in the Simple API at this time, but I have two simpler suggestions:

• Create a small piece of M code that does what you want, and call that from mg-dbx-napi.
• Code a small C function that calls the underlying ydb_set_s() / ydb_set_st() in a loop. Under the covers, that's basically what the MERGE command does.

Regards

– Bhaskar

[Maury Pepper]

My recollection is that the downside of the MERGE command is that it is a single call to the database which can be indeterminately long due to the unknown size of the "from" argument. Thus, depending on implementation, it may cause issues with locks, interrupts, TP, etc.

    -maury-

To view this discussion on the web visit https://groups.google.com/d/msgid/everythingmumps/cd95c202-8a78-4c45-83a2-dae0928a300fn%40googlegroups.com.