Fhirbase observation insertion is slow

[nisha...@gmail.com]

Hi ,

I have around 6GB data in my fhirbase and even with that my db is crying for observation inserts. out of 6GB, 4GB is only observations. Reads are faster but inserts are too slow. Please suggest some solution 

[Николай Рыжиков]

Hi, do you use fhir_create_resource function?

This is complex operation.

Please trace which step is slow - https://github.com/fhirbase/fhirbase-plv8/blob/master/src/fhir/crud.coffee#L120

May be this one  - https://github.com/fhirbase/fhirbase-plv8/blob/master/src/fhir/crud.coffee#L103

73's nicola

On 9 April 2018 at 14:53, <nisha...@gmail.com> wrote:

Hi ,

I have around 6GB data in my fhirbase and even with that my db is crying for observation inserts. out of 6GB, 4GB is only observations. Reads are faster but inserts are too slow. Please suggest some solution 

--
You received this message because you are subscribed to the Google Groups "FHIRbase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to fhirbase+unsubscribe@googlegroups.com.
To post to this group, send email to fhir...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/fhirbase/6280e626-30f9-42ef-9fae-6e8a2c753cb7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[nisha...@gmail.com]

Yes iam using that. Now I increased th db size and I have my fhirbase hosted in aws. But my transactions are getting slower . I have around 2.8 million records in my observation table and i am trying to update 10 records out of 2.8 million using transaction . Its taking around 3-4 minutes and its affecting my ui performance also. Can any one help me to solve this. I even tried to delete some of my records, even my deletes also is slower.

On Monday, 9 April 2018 18:26:03 UTC+5:30, Николай Рыжиков wrote:

Hi, do you use fhir_create_resource function?

This is complex operation.

Please trace which step is slow - https://github.com/fhirbase/fhirbase-plv8/blob/master/src/fhir/crud.coffee#L120

May be this one  - https://github.com/fhirbase/fhirbase-plv8/blob/master/src/fhir/crud.coffee#L103

73's nicola

On 9 April 2018 at 14:53, <nisha...@gmail.com> wrote:

Hi ,

I have around 6GB data in my fhirbase and even with that my db is crying for observation inserts. out of 6GB, 4GB is only observations. Reads are faster but inserts are too slow. Please suggest some solution 

--
You received this message because you are subscribed to the Google Groups "FHIRbase" group.

To unsubscribe from this group and stop receiving emails from it, send an email to fhirbase+u...@googlegroups.com.