gabijack.com
Gabi Jack's Blog | Tag Archives: MySQL
http://gabijack.com/tag/mysql
In search of a faster query. June 14, 2015. Recently, as I was fixing a minor bug in one of our applications at work, I had the opportunity to witness what a great difference a simple query can make. The bug involved a very slow query, that was doing a join between a couple of tables that had grown too large in size. The query, in Rails, was as follows:. Model1.select('attribute1, model1.id').joins(:model2).order(:attribute1). Model1 ids = Model3.joins('INNER JOIN model2 on model2.model1 id ...That last ...
gabijack.com
Gabi Jack's Blog | Category Archives: personal
http://gabijack.com/category/personal
Diary of a Junior Dev: The Joys of Building. November 1, 2015. If someone offers you an amazing opportunity and you’re not sure you can do it, say yes – then learn how to do it later. – Richard Branson. Oh, but did I mention this needed to be done in record time? I’m not sure the specifics of why, but we had a very tight deadline. When the site was finally released on schedule and the customer expressed their happiness, I was beaming with pleasure. There’s no way to describe the feeling of sati...I hope ...
