In this blog post, I will tell you some queries/ tricks to speed up your application using the power of a database. I am using Postgres and ActiveRecord rails, so all questions are related to these, but you can tell them with your database. Recently I got some performance issues when our user base increased … Continue reading Leverage A Database To Gain An Optimum Speed For Your Application
Month: October 2017
Upload Your Large CSV Efficiently Using Rails
Active-record is an abstraction layer that facilitates creation, deletion and use of ORM objects whose data requires persistent storage to a database. This keeps us away from having to think too much about SQL level queries and makes it very easy for us to work with data. It gives us super easy interface that helps us to do “almost” anything that we can do with bare SQL statements. Apart from the basic CRUD operations, active-record lets us do more complicated database stuff like pick a group of records based on a criteria, order them, join tables, perform mathematical operations, etc.
Active-record pattern is liked by most because of the above mentioned reasons. But using active-record solely may not help when your application scales.
For example, active-record does not have a support to bulk insert into the database. Ofcourse we can use gems to do that, but I personally…
View original post 661 more words
Josh Software 