Sharding Question
Opened this issue · 1 comments
Hello,
I have been working on increasing the performance of measure calcualtions and configured a sharded environment. I am using one database server and created 6 shards which now use all available CPUs (8) when calculating measures. However, it still takes approximately 2-3 minutes to calculate each measure. here is a screenshot of the configuration.
1.) Are there any ways to increase the efficiency?
2.) Is there a way to temporarily hide the filter functionality so the pre-calculated measures are not easily deleted through the 'clear all patient/provider filters' button?
I understand this would be a temporary work around but any help would be appreciated. Let me know if anyone else has had some success sharding the database.
Thank you!
Nick
Nick - how many patients are you processing that it's taking 2-3 minutes? We have an instance with 800K+, and a single measure for all of these patients take ~15 minutes. And we were happy with that :)
I believe the only way to scale is to keep adding more shards. You can distribute this across additional servers if you're currently at the CPU limit on your server now.