Skip to main content

Tracking and fixing issues for query optimisation

Queries being executed along with time and space complexity helps to optimise database in the best possible ways. Though this topic has been covered vastly, i will pull the very basic ones for the beginners.

In rails applications, active record is being used as a wrapper for SQL databases. In order to view each query which is being executed below to get a clear idea, add the corresponding MySQL query 

ActiveRecord::Base.logger = 

Use joins to combine tables if they have a association and then fetch data. When you loop over this fetched data in first place, queries to access related data from other model will not be executed as it is already available.
Eager loading will not work in NoSQL databases as in case with MongoDB due to the absence of joins.Even though 
The identity map in Mongoid is a current aid to assist with excessive database queries in relations, and is necessary for eager loading to work. Refer:   Mongoid Identity Map

Add to_a or .entries or .first after query as mongoid returns only the criteria.

        For ex- User.where(name: /a/).entries

so when that criteria is used, queries for each operation are fired. This will makes sure the entire data set is available and any operation will be performed on that data without hitting server to fetch data.

MongoDB works with lazy loading as it returns only criteria in first place and when you loop over the data each query is fired to fetch single row at a time which can be avoided as said above.


Popular posts from this blog

upload images to AWS::S3 in ruby using aws sdk gem

Using gem aws-sdk for a ROR application for uploading images to s3
Uploading images to a fixed bucket with different folders for each object or application. The s3 keeps a limitation on the number of buckets creation whereas there is no limitation for content inside a bucket. This code will upload image for a user to s3 using aws-sdk gem. The bucket and the image uploaded are made public, so that the images uploaded are directly accessible. The input is takes is the image complete path where it is present, folder in which it should be uploaded and user_id for whom it should be uploaded. def save_screenshot_to_s3(image_location, folder_name,user_id) service = => ACCESS_KEY_ID, :secret_access_key => SECRET_ACCESS_KEY) bucket_name = "app-images" if(service.buckets.include?(bucket_name)) bucket = service.buckets[bucket_name] else bucket = service.buckets.create(bucket_name) …

Fresh server start after instance degraded

So the issue was, amazon issued an warning regarding the server to be terminated, before i could think of making an backup the instance stopped.

The troubleshoot operations like reboot, stop and start didn't worked.
Simple Steps to start a fresh instance with the previous content on server.