spot7.org logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML Categories

Optimising Eager Load


The best way to do this would probably be changing your data model to a polymorphic relationship and using a belongs_to association in MediaItem

class MediaItem < ActiveRecord::Base
  belongs_to :media_content, :polymorphic =>
true
end

class Photo < ActiveRecord::Base
  has_many :media_items, :as => :media_content
end

class Video < ActiveRecord::Base
  has_many :media_items, :as => :media_content
end

MediaItem.includes(gallery: {media_items:
[:media_content]}).featured.rank(:position_in_featured)

For this to work you need to have a type media_content_id and media_content_type columns on MediaItem.

EDIT: There is even a note in the docs that eager loading should work in your case in the last paragraph of this section: http://api.rubyonrails.org/classes/ActiveRecord/Associations/ClassMethods.html#module-ActiveRecord::Associations::ClassMethods-label-Eager+loading+of+associations


Categories : Ruby On Rails

Related to : Optimising Eager Load
C# Compiler Optimising Loop?
Your problem is inside of the Block method, and now that I look at the comments, it appears that Henk Holterman has already brought this up. It will only fail when _lastReset.Add(_rateLimitSpan) and DateTime.UtcNow are equal. This doesn't happen very often, hence the reason why it fails intermittently. A fix would be to change > to >= on this line: if (DateTime.UtcNow > _lastReset.Add(_

Categories : C#
Optimising a large number of rows in a Rails app database
If you are using Rails 3 and want to keep using a relational database your best option is to use table partitioning. If you use PostgreSQL you can use the partitioned gem and check this slides to get an overview. If you want to use Rails 4, since the partitioned gem is not compatible with ActiveRecord 4, I would advise you to use manual partitioning, you can use the year as your partition point

Categories : Ruby On Rails
New to HTML and CSS and I need help optimising my code. Also have a few issues with dynamic sizing of elements
Having those Ids classes with identical code is not efficient: Instead of using #id to style an element, use classes. Create a class for all the properties that are identical and assign this class to all the HTML elements. For example, instead of repeating font-family: 'Kalam', cursive; width: 80% in several #id create a class ".typography-big" or whatever and then apply the style to all the h

Categories : HTML
Eloquent eager loading do not joins?
I found the solution in a Laracasts video (thanks Jeffrey!). I need to use join('users', 'users.id', '=', 'ocurrences.user_id'). It's a bit logical but I thought with do joins too. Anyway, here's the final solution: /** * Get random ocurrences for home * @return Eloquent */ public static function randomForHome() { return static::join('users', 'users.id', '=', 'ocurrences.user_id') ->

Categories : PHP
REST API and eager loading rested resources
I would go with the following REST-style URLs: GET /authors - to get list of all authors GET /authors/{authorId} - basic info about the concrete author in one request GET /authors/{authorId}/detailed - detailed info about the concrete author in one request Additionally, you could have the following methods to extract specific info about author: GET /authors/{authorId}/images - get all images

Categories : Rest
Recently Add
Groups and Users has many oder has many through?
Rails format specifier differences
Capistrano can not create symlinks: file exist
Admin can't delete users. Ruby on Rails 3 - Michael Hartl
Don't show user name who create post
Using Wicked with Devise (2 step signup process)
RubyOnRails Rake test failures
Rails session start event handler
Why ActiveModel::ForbiddenAttributesError error?
How can i track the issue in production RAILS
Cannot install spree gem - ERROR: invalid gem: package is corrupt
Why are the nested resources for Devise authentication not working?
Rails Devise - how to open access to the site root
Rails: respond_with the same template for two methods
rails with postgresl database "role postgres does not exist"
Instance variable in Rails helper not set
Monkey patch rails 3.2 rake task
Rails_admin: Should I have admin_user or user with admin role to manage users and admin panel
undefined method `attachments' for nil:NilClass
Memory usage increase with Ruby 2.1 versus Ruby 2.0 or 1.9
Can a Rails app be deployed without using Heroku Toolbelt? If so, how?
Enable random access to collection with MongoDB
libmysqlclient-dev installation fails
undefined method `name' for nil:NilClass. Can't find @followed.name but @followed is set
Allowing an arbitrary domain and subdomain in session_store.rb
Pushmeup Gem - Can't send push notifications in Active Admin model
Rails console does not start
GitHub Import: Could not locate Gemfile
AWS::S3::PermanentRedirect in SongsController#index "The bucket you are attempting to access must be addressed using the specified endpoint"
automatically create ActiveRecord parent for association
© Copyright 2017 spot7.org Publishing Limited. All rights reserved.