New Contributor
Posts: 2
Registered: ‎09-18-2018

Hotspotting of System.catalog table in Phoenix resulting in slow get queries

Hi, I am using phoenix 4.5 version and the get call on table with global secondary index is very slow ~ 2 seconds. From the server metrics I see that the send bytes is one of the region server with system.catalog table is around 120MB/ sec while on other region servers it is in KB. Is this because in every get call client is fetching the system.catalog table info. And if it is then, how to avoid the hotspotting of this system.catalog table.