โ10-04-2017 11:02 AM
Hi,
Currently when I use Oracle select/Oracle execute snaps to query data from Snaplogic, it will return multiple documents as output from those snaps(one row per doc).
Is there a way i can merge them together into one json array or one doc?
Thanks
โ10-04-2017 11:56 AM
One way of achieving faster response is to provide limit and offset to the callers using this Ultra API.
LIMIT and OFFSET can be easily implemented in database queries!
You can easily implement this and thereby dont expose the whole set of data when not needed.
โ10-04-2017 12:41 PM
No, in our case, we have to expose all data from one select * query.
โ10-05-2017 09:59 AM
Or you could try doing the group by in python since โScriptโ snap does support ultra. I know this isnโt ideal but at least this might satisfy your business requirements.
โ10-05-2017 11:56 AM
Yes, Script is the only way we can do this which can provide faster performance as well.
But we would avoid to use script or any snap development. That defeat the purpose of โCitizen integrationโ as what Snaplogic advertised.
โ10-05-2017 02:05 PM
What is your expectation in terms of time and results?
200 docs in 1 sec or 3 secs or subseconds?
What config do you have? How many nodes/FMs?