Robin Arnold

Note that the 2 GiB limit applies to the resource after it is serialized as JSON and compressed. With offloading to Azure Blob, the max resource size is larger, although...

Also found that the payload offload parse call was ignoring the elements variable so no subsetting was supported, causing integration test failures with the Azure e2e updated added to the...

I don't think that payload offloading is actually happening because the configuration in `fhir-server-config-postgresql-azurite.json` specifies the standard persistence factory: ``` "factoryClassname": "org.linuxforhealth.fhir.persistence.jdbc.FHIRPersistenceJDBCFactory", ``` For offloading, the persistence factory needs to...

Confirmed that we are now using an azurite payload configuration in one of the integration tests: ``` [8/24/22, 10:31:43:227 UTC] 00000028 FHIRRestServl I Received request: tenantId:[default] dsId:[default] user:[fhiruser] method:[POST] uri:[https://localhost:9443/fhir-server/api/v4/ActivityDefinition]...

To deserialize any com.ibm.fhir.model resource you need to use FHIRParser: ``` try (InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream(bundlePath)) { final Bundle bundle = (Bundle) FHIRParser.parser(Format.JSON).parse(is); ... } ``` The parser performs a...

You might also want to take a look at our FHIRClientImpl which uses jax-rs configured with custom components to handle the serialization/deserialization of FHIR resources. This is used extensively in...

@anshul90 please let us know if the above info is helpful.

The same query structure is used to obtain the resource count so we do need to perform this filtering as part of the query itself. We therefore need to find...

The QueryUtils would log the query string, but only if `com.ibm.fhir.database.utils.query.*=FINE`. It would probably make sense to have the logger passed as an argument.

``` fhirdb=> explain analyze SELECT LR0.RESOURCE_TYPE_ID, LR0.LOGICAL_RESOURCE_ID FROM FHIRDATA.LOGICAL_RESOURCES AS LR0 WHERE LR0.IS_DELETED = 'N' AND LR0.RESOURCE_TYPE_ID IN (9,12,1,2,149,3,4,5,6,7,8,10,11,13,14,15,16,17,18,150,19,20,21,151,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,45,46,47,48,49,50,51,152,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,153,67,68,69,70,71,72,154,73,74,75,76,77,78,79,80,81,155,92,93,94,95,96,156,97,98,99,100,101,102,157,103,104,105,106,107,108,109,110,111,112,113,114,158,115,116,117,118,119,120,122,124,125,126,127,128,129,130,131,132,159,160,133,161,140,141,142,143,144,145,146,147,148) AND EXISTS ( SELECT 1 FROM FHIRDATA.LOGICAL_RESOURCES AS LR1 WHERE LR1.LOGICAL_RESOURCE_ID...