Everyone thinks of creating index, but nobody pays attention towards removing them once they are created and not required .Too many indexes or unnecessary index can degrade your DB performance. To Optimize indexes in mongo we need to understand following things : How indexes works in mongoDB: Let’s say we have created compound...
Second day of FullStack, 2016 London was full of knowledge, great workshops and more amazing people. It felt so good to meet people who have developed some awesome products that we have been using since long and provide an experience to our customers. I got a chance to talk with Heroku and twillio and they explained their future vision to...
In the previous blogs, Overview of Database Testing and What should we test in a Database we got a fair idea about database testing concepts and types of database testing. Now with this blog, we are moving a step ahead to enhance our knowledge by defining the keys steps that will help in performing “Database Testing” DBMS vs RDBMS ...
In the previous blog on Overview of Database Testing, we had discussed the basic concepts like database, database testing, the need for database testing and how to perform database testing. In this blog, we will be diving deep into the world of database testing and throw some light on what we need to test in a database? Types of Database...
In my previous blog post, I wrote about Cost Optimizations for the various AWS resources. The script consisted of six methods and the overall time required for the script to execute was roughly about 15-20 mins. While the script is running, it used to slow down my system. Also, there was a time consumption due to many reasons like...
Cypher Query Language or CQL is the language to traverse and update graph structures in Neo4J. The language is similar to SQL and provides a declarative syntax for querying. However, it is worth mentioning that unlike SQL in which one needs to provide the complete procedure how to get records by defining joins etc. CQL's language...
As we know AWS provides a good edge in terms of cost over the on-premises data center or in a co-location environment with its On Demand and Reserved pricing. As it is rightly said "Reducing the overall cost is a high priority" and it is true for any organization whether big or small. By using AWS we can lower the IT costs, compute...
Neo4J is a NoSQL database that stores information in the form of a huge property graphs where tuples/rows (nodes) are connected to each other with relationships (edges) both of which can have variable number of properties associated with them. Traversing data in the form of graphs implies that we can explore highly connected...
With a mushrooming number of internet users, the data creation, storage, and retrieval has reached new heights and so has the number of issues arising due to these activities. The major source of origin of these failures/defects lies in minimal attention paid towards database handling and testing. So what do we understand by Database and...
Our cloud DevOps engineers have been using Elasticsearch on production environment for an e-commerce website for quite a while. The website has one admin server to manage activities such as adding new production, managing discounts on various items, fetching reports etc. We came across a requirement where downloading reports from admin...
Our DevOps team was using Found for one of our projects in the production environment. We have been facing a problem with found where it’s memory pressure frequently goes up and does not drop down so easily and until the time it remains up the Found was not able to serve the requests. Then, we decided to move to self-hosted...