python - How can i speed up this django orm generated query? -

-

i have movie table , genre table , moviegenre table genres movie has.

the django orm came query when i'm trying movies have @ least of genres target movie has in common.

select "movies_movie"."id", "movies_movie"."imdb_id", ..etc..   "movies_movie"."last_ingested_on",  count("movies_movie"."id") "count",  count("movies_moviegenre"."genre_id") "genres_count"  "movies_movie"  left outer join "movies_moviegenre" on ( "movies_movie"."id" = "movies_moviegenre"."movie_id" ) inner join "movies_moviegenre" t4 on ( "movies_movie"."id" = t4."movie_id" )  inner join "movies_moviegenre" t6 on ( "movies_movie"."id" = t6."movie_id" )  ("movies_movie"."last_ingested_on" not null  , not ("movies_movie"."imdb_id" = 'tt0111161' )  , "movies_movie"."type" = 'feature'  , "movies_movie"."certification" = 'r'  , t4."genre_id" = 1 , t6."genre_id" = 10 )  group "movies_movie"."id", "movies_movie"."imdb_id", "movies_movie"."movie", "movies_movie"."type", "movies_movie"."year", "movies_movie"."tagline", "movies_movie"."plot", "movies_movie"."runtime", "movies_movie"."rating", "movies_movie"."certification", "movies_movie"."budget", "movies_movie"."box_office_revenue", "movies_movie"."poster_url", "movies_movie"."trailer_url", "movies_movie"."mood_data", "movies_movie"."created_on", "movies_movie"."modified_on", "movies_movie"."last_ingested_on" having count("movies_moviegenre"."genre_id") >= 2  order "count" desc

can see causing slow, it's taking 1107.26499557 ms isn't acceptable. in advance

explain output: http://explain.depesz.com/s/lev

not sql expert double inner join looks strange me, strange in equivalent.

left outer join "movies_moviegenre" on ( "movies_movie"."id" = "movies_moviegenre"."movie_id" ) inner join "movies_moviegenre" t4 on ( "movies_movie"."id" = t4."movie_id" ) inner join "movies_moviegenre" t6 on ( "movies_movie"."id" = t6."movie_id" )

said adding index columns of clause? i'm looking @ these in particular looks index candidates:

and "movies_movie"."type" = 'feature' , "movies_movie"."certification" = 'r' , t4."genre_id" = 1 , t6."genre_id" = 10 )

see https://docs.djangoproject.com/en/1.7/topics/db/optimization/#use-standard-db-optimization-techniques


Comments

Post a Comment

Popular posts from this blog

google chrome - Developer tools - How to inspect the elements which are added momentarily (by JQuery)? -

-
i looking @ how website designed using inspector in chrome. can use firefox developer tools or firefox web developer add-on or chrome web developer extension. so website has slide-show , using jquery it. looking @ markup , css in inspector, i see 2 things constantly changing slides change: one opacity css property understandable, i'd see changing values, changes fast see read anything. second- a div added in div slides change momentarily , moment when appears short notice except div . so question is there way stop slideshow can temporarily rid of blinking sort of effect (by speedy adding , removal , changing of elements , values)? where can inspect div element gets added such short moment , , gets removed? , can see changes in value of opacity takes place? is there way stop slideshow can temporarily rid of blinking sort of effect (by speedy adding , removal , changing of elements , values)? if opacity animated css transition or animation,
Read more

angularjs - Showing an empty as first option in select tag -

-
my app showing empty select field first entry. have read other solution given , tried still not working. my controller code is: .controller('usercreatecontroller', function(user,profile,auth) { alert("hello"); var vm = this; vm.type = 'create'; profile.all() //this service fetch profiles shown in select field .success(function(data){ vm.profile = data; }); vm.userdata.profile = vm.profile[0]; //here have set default value select field and html page is: <label class="col-sm-2 control-label">profile</label> <div class="col-sm-8"> <select ng-model="user.userdata.profile" ng-options="person._id person.profilename person in user.profile"> </select> </div> hierarchy of vm.profile { "_id": 46, "profile": objectid("5516498e95b84548156db754"), "isactive": true, "password": "$2
Read more

php - Cloud9 cloud IDE and CakePHP -

-
i attempting cakephp running on cloud9, cloud based ide. unaware, cloud collaboration ide intermixes services such bitbucket. site gives sudo rights, , installed cakephp using these instructions: https://www.digitalocean.com/community/tutorials/how-to-install-cakephp-on-an-ubuntu-12-04-vps when attempt run database exported machine cakephp installed, error message "url rewriting not configured on server." attempted solve issue using official guide cakephp: http://book.cakephp.org/2.0/en/installation/url-rewriting.html but no cigar, same error message. has gotten cakephp working, or aware of cloud ide free/low cost cloud9 support cakephp? here's how got working now: sudo apt-get update sudo apt-get install php5-intl curl -ss https://getcomposer.org/installer | php -- --filename=composer ./composer create-project --prefer-dist cakephp/app this creates project in /app default. move workspace docroot: mv app/* ./ mv app/.* ./ rm -rf app then de
Read more