mORMot Open Source

Stemon63

Member

Registered: 2016-10-24

Posts: 50

Mormot 2 - RetrieveListJson "compact" features

Hi,
in MOrmot 2, it's possibile to add some options to RetrieveListJson() for "compact" Json result?
I intend similar to the [ToNonExpandedJson] for a packed "CSV" format and [DontStoreVoid] for smaller Json result (alternative of course).
I want obtain best performance possible without convert Json result in TDocVariant with performance penalty, and for response with a compact Json result, where possible.
Thanks a lot!!

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Mormot 2 - RetrieveListJson "compact" features

IIRC RetrieveListJson() has aForceAjax=false by default which returns the "compact" JSON result.
You can also force it by setting TRestServer.NoAjaxJson := true.

Note that you have already an IRestOrm.RetrieveDocVariantArray() method to create a TDocVariant.

Stemon63

Member

Registered: 2016-10-24

Posts: 50

Re: Mormot 2 - RetrieveListJson "compact" features

It seems that only  aForceAjax=false by default don't works.
Instead with TRestServer.NoAjaxJson := true it works well. Thanks a lot!

A different serialization:
There is a way for obtain a direct serialization for a  JSON with "[DontStoreVoid]" option for a
IRestOrm.RetrieveDocVariantArray() (or other Retrieve...)? I don't find this capability natively.
Naturally the fastest way possible...

Thanks in advance!

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Mormot 2 - RetrieveListJson "compact" features

There is no such method directly.
Because in practice, it is likely to be slower than always putting all fields.

My guess is that a custom method working at ORM level, using TOrmPropInfo.IsValueVoid and TOrmPropInfo.GetVariant could help, if you really need it.

Stemon63

Member

Registered: 2016-10-24

Posts: 50

Re: Mormot 2 - RetrieveListJson "compact" features

OK, perfect.
Thanks a lot :-)