by heimdalladmin | Aug 17, 2021 | GCP, Web Scale
Background Horizontally scaling your SQL database involves separating the write-master from read-only servers. This allows the write server to perform dedicated write operations while read queries are offloaded to separate replicas. However, this architecture may...
by heimdalladmin | Aug 17, 2021 | GCP, Web Scale
Application-database inefficiency (e.g. repeated queries, network latency) is a primary cause of performance bottlenecks. Query caching is used to improve database responsiveness and scale. But caching is not without its challenges; knowing what to cache and when to...
by heimdalladmin | Jun 3, 2019 | Azure, HA Failover, Web Scale
One of the main causes of slow application performance is inefficient interaction between the application and database. Today, developers spend precious resources on building home grown solutions to optimize SQL performance. For IT organizations, they are...
