we have licensed customer instance - DEV
we want to access table data with multiple rows/columns and fetch the required row based on the condition from wm io API Gateway. Previously we have used AWS Dynamo DB which has option to create a table and store data with multiple rows/columns and fetch any single record based on condition. but the call from wm io API Gateway to AWS Dynamo DB adds the time delay of around 400 ms for turnaround and we are looking for similar option internally in wm io api gateway to improve the performance. Do we have any DB inside wm io?
SAG has provided options like account store and reference data but it has lot of limitations and does not fulfill our requirement.
Account store works only for GET calls and reference data is fetching all records but not single record, join condition does not apply.
we are using 10.15.0.0.1013 version wm io