Manoj K SardanaComposite index to evaluate ORDER BY and PREDICATE togetherA few weeks back I have written a story regarding the indexing strategy on database table to improve the performance of a query in one of…3 min read·Jan 29, 2021----
Manoj K SardanaMicro Services communication — Synchronous/Asynchronous, Pull/Push or queue basedWhile everyone understand that micro service based applications has its own set of benefits like scaling individual component, independent…4 min read·Dec 30, 2020----
Manoj K SardanaAPI driven application Vs API Drive businessMicro service based application is the new trend now. The foundation of this architecture is the capability of the various application…3 min read·Nov 30, 2020----
Manoj K SardanaAuto Scaling in CF based PaaS cloud — Myths Vs realityRecently while exploring the best way to scale our CF based application on IBM cloud, we busted one of our belief on the auto scaling part…4 min read·Nov 20, 2020----
Manoj K SardanaWhat’s better — Horizontal or Vertical Scaling for effective resources managementAuto scaling generally comes with its 2 flavors- Horizontal and vertical scaling. While horizontal means increasing the number of…3 min read·Nov 17, 2020----
Manoj K SardanaImportance of timeouts for webpages, APIs and SQLs micro service based applicationIn a micro service based application, we generally have independent applications (aka micro services) developed based on the single…3 min read·Nov 12, 2020----
Manoj K SardanaSelecting the correct Index for better database query performanceBeing an SRE lead, my first responsibility is always to make sure that system is performing at optimal level and remain stable…4 min read·Nov 4, 2020----
Manoj K SardanaBest place to enforce Business Rules and constraints on Data attributesRecently as part of the activity of making our application more stable and improve performance, we were trying to find out the best…3 min read·Oct 29, 2020----
Manoj K SardanaDB migration — Monolithic to Micro Services — Challenges and guidelinesTo continue from where I left in my last story, today I like to list down few of the guidelines/challenges we face during our DB migration…4 min read·Oct 10, 2020----
Manoj K SardanaDatabase Journey from Monolithic to Micro serviceMicro service based architecture for the applications are quite a trend today. This popularity is backed by the advantages like…2 min read·Oct 7, 2020----