By having appropriate indexes on your MySQL tables, you can greatly enhance the performance of SELECT queries. But, did you know that adding indexes to your tables in itself is an expensive operation, and may take a long time to complete depending on the size of your tables? During this time, you are also likely to experience a degraded performance of queries as your system … [Read more...] about Best Practice for Creating Indexes on your MySQL Tables
performance
What’s the Best PostgreSQL High Availability Framework? PAF vs. repmgr vs. Patroni – Infographic
Wondering which high availabilityframework to use for your PostgreSQL deployments? We compared the top 3 frameworks, PostgreSQL Automatic Failover (PAF) vs. Replication Manager (repmgr) vs. Patroni, in our Managing High Availability in PostgreSQL series. In these blogs, we dove deep into how the frameworks work, their setup requirements, pros and cons, and how they … [Read more...] about What’s the Best PostgreSQL High Availability Framework? PAF vs. repmgr vs. Patroni – Infographic
Shadow IT is Today’s Biggest Cyber Threat to Businesses
Data security is only as strong as an enterprise's weakest vulnerability. Today, IT officers must not only protect company networks against external threats “ but also internal ones. For example, the often-overlooked danger of shadow IT can lead to disaster if left unchecked. Fortunately, technology leaders can stop the slow creep of shadow IT initiated by likely well-meaning, … [Read more...] about Shadow IT is Today’s Biggest Cyber Threat to Businesses
Ad Hoc Javascript Performance Benchmarking
At Exago, we are always looking for ways to further improve the application's user experience. While these advances are most noticeable in major enhancements such as our newly-released dashboard designer and formula code completion, upgrades to client- and server-side performance are just as important. For Exago's v2017.2 release, I was tasked with speeding up our client-side … [Read more...] about Ad Hoc Javascript Performance Benchmarking
Why Educational Systems Should Consider Big Data
Advances in technology have enabled good decision making in most educational institutions following the increased use of big data. The policy makers in the institutions have been using big data to understand the sentiments about the school and make systematic improvements to the student's performances. The term big data refers to a large amount of information flowing through … [Read more...] about Why Educational Systems Should Consider Big Data
