jro_apps/redmine Files · app/controllers/auto_completes_controller.rb

scm: git: performance improvements in fetching revisions (#8857, #9472)...

scm: git: performance improvements in fetching revisions (#8857, #9472) Parse a revision for a given branch, just if we haven't parsed it for any branches before. Moved the db check to for existing revisions into a grouped search. Search for many revisions at once: this reduces db load. Revisions are grouped into sets of 100. This is to improve memory consumption. There will be just one query instead of each 100. The above two methods significantly increase parsing speed. Test case was a git repo with 6000+ commits on a master branch, and several other branches originating for master. Speed improved from 1.4h to 18min. Contributed by Gergely Fábián. git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@9144 e93f8b46-1217-0410-a6f0-8f06a7374b81

Toshi MARUYAMA - - Load All Authors

File last commit:

r6676:e028e542584f


                r9024:999a4ba30d7b

Download file

             auto_completes_controller.rb
        
                    27 lines
            
             | 770 B
            
                | text/x-ruby
            
             |
                RubyLexer
            
             / app / controllers / auto_completes_controller.rb
          
                    History
                
                 |
                  Annotation
                 | Raw
                 |Copy content
                 |Copy permalink

      class AutoCompletesController < ApplicationController

        before_filter :find_project

        def issues

          @issues = []

          q = params[:q].to_s

          query = (params[:scope] == "all" && Setting.cross_project_issue_relations?) ? Issue : @project.issues

          if q.match(/^\d+$/)

            @issues << query.visible.find_by_id(q.to_i)

          end

          unless q.blank?

            @issues += query.visible.find(:all, :conditions => ["LOWER(#{Issue.table_name}.subject) LIKE ?", "%#{q.downcase}%"], :limit => 10)

          end

          @issues.compact!

          render :layout => false

        end

        private

        def find_project

          project_id = (params[:issue] && params[:issue][:project_id]) || params[:project_id]

          @project = Project.find(project_id)

        rescue ActiveRecord::RecordNotFound

          render_404

        end

      end

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

				class AutoCompletesController < ApplicationController
				before_filter :find_project

				def issues
				@issues = []
				q = params[:q].to_s
				query = (params[:scope] == "all" && Setting.cross_project_issue_relations?) ? Issue : @project.issues
				if q.match(/^\d+$/)
				@issues << query.visible.find_by_id(q.to_i)
				end
				unless q.blank?
				@issues += query.visible.find(:all, :conditions => ["LOWER(#{Issue.table_name}.subject) LIKE ?", "%#{q.downcase}%"], :limit => 10)
				end
				@issues.compact!
				render :layout => false
				end

				private

				def find_project
				project_id = (params[:issue] && params[:issue][:project_id]) \|\| params[:project_id]
				@project = Project.find(project_id)
				rescue ActiveRecord::RecordNotFound
				render_404
				end

				end