Redmine

I have this fragment of production.log file

Started GET "/projects/test/dmsf" for 127.0.0.1 at 2013-09-19 14:12:02 +0400
Processing by DmsfController#show as HTML
...
Rendered plugins/redmine_dmsf/app/views/dmsf/show.html.erb within layouts/base (11633.7ms)
...

Completed 200 OK in 11656ms (Views: 6990.4ms | ActiveRecord: 4661.3ms)
how can I look the MySQL query for this string (11633.7ms)?
and what does it mean: "Views: 6990.4ms | ActiveRecord: 4661.3ms"?

About 3500 queries are carried out when the dmsf page are loaded. Majority of they are connecting with table 'dmsf_file_revisions'. Is it possible not to address to this table? (Because these queries last 13 sec )

My dev team has been experiencing this issue too and I've been watching this post for a while waiting for any activity. How can we help fix this?

The user interface will be about 3x faster in the next release 1.4.7.

Thanks so much for addressing this! Gratefully, when might that release happen?

Middle of January, I believe.
If possible test 1.4.7-devel and provide a feedback, please.

Thanks! I will gladly test that for you!

As a side thought, I wonder if it would be any additional performance boost to provide a configurable option to disable subdirectory file count display and total subdirectory file size display. Do you think that might also help?

That's one of measures taken to speed up the application.

WOW! devel-1.4.7 is MORE than 3x faster for my repo! Very nice! Are there any known showstopper issues with devel-1.4.7? I am considering putting it on our production server until the official release. Does that sound like an extremely risky idea in your opinion?

There is no open issue at the moment but still it is needed some time for testing. I see no risk in use of the development version but I'd personally wait until 1.4.7 is released in January.

redmine-2.2.4\plugins\redmine_dmsf\app\models\dmsf_folder.rb commenting out these lines will be faster page loading

def deep_size
#size = 0
#self.files.visible.each {|file| size += file.size}
#self.subfolders.visible.each {|subfolder| size += subfolder.deep_size}
#size
end

Page DMSF became loaded fast enough, the number of queries to the database was reduced to 700.

Karel,

As I mentioned earlier, my team and I are very appreciative of this work and want to help ensure your update goes as planned (without getting in your way). Please let me know if there are any other features I can help test in addition to the load-times discussed here. Also, is there an email list or a way to get some notification when the updated release happens?

Many thanks,
Chris

Please watch the plugin home page https://github.com/danmunn/redmine_dmsf. If you can test the development version, any reported bug is welcommed.

I will keep testing independently but I am afraid my testing is too simple. if you let me know when you get to a point where the development branch is at a reasonable "beta" state (where it will not cause any known catastrophic issues with our database), I will install it on our team's server and let our engineers really give it a work-out.

Thanks,
Chris

That's 1.4.7-devel version now. If you can test it, please do so.

DMSF 1.4.7 has just been released.

Excellent! Thank you so much for going out of your way to notify me here too.

Chris

I've just finished a next version 1.4.8. It's just before releasing. If you can test it, please do so.

https://github.com/danmunn/redmine_dmsf/tree/devel-1.4.8