I'm using webfm on my music site by attaching mp3 and flac files to each single track node. We use these files to be downloaded by users with a specific role. I also use views to display a table of each track for example our recent audio page http://www.polybonk.com/audio I used the devel module to see how long it took to execute this page and it took 35101.95 ms. compared to 1370 ms. with the module disabled, thats a huge difference

My server isn't exactly slow either. It started to slow down with the more content we added with attached files.

I wish to provide you with more useful information but I'm not exactly sure what you need in order to understand why this is happening, please let me know what you need.

CommentFileSizeAuthor
#2 views_export.txt4.74 KBtom-d

Comments

andremolnar’s picture

andremolnar commented

When inspecting with Devel module - can you see what specifically is contributing to the slowdown? Is there a particular query that is taking a long time?

Do you have any other debugging tools at your disposal? Can you profile the page execution (function call trace with execution times)?

If not, it would still help to understand what type of view you are building and what is included in that view.

andre

tom-d’s picture

tom-d commented
StatusFileSize
new views_export.txt4.74 KB

Thanks Andre

pager_query, cache_get, sess_write, and og_handler_post_count_new all take a long time with webfm enabled

I'm very new to devel and I'm not completely sure how to use it, how would I go about exporting the output so it can me useful to you. Do you have any suggestions to what other useful debugging tools I could use to help you more.

tom-d’s picture

tom-d commented

This is what devel output looks like

http://polybonk.com/files/devel_export.html

andremolnar’s picture

andremolnar commented

Thanks - i've saved that devel_export - so you can take that off your server now. I'll take a look and see what i can find.

andremolnar’s picture

andremolnar commented

I took a look at the devel trace - and I'm not entirely sure how WebFM is responsible for this. All webfm related activities are executed in 0.08 seconds or so. The most expensive query on the page seems to be from the 'who's on-line block' you have enabled.

Can you try disabling that block and seeing if there is a change?

andre

tom-d’s picture

tom-d commented

I can't make any sense of it, I tried disabling all the blocks, I tried to disable other third party modules that resulted in the same problem.

Is there any other test I can do that will help find out more about how to fix this?

tom-d’s picture

tom-d commented

I have discovered it may not be webfms fault after all

I'm using ubercart and I have an add to cart field in my views list and but simply removing this field the generation time jumps from 16644.24 ms. to 343.69 ms. !

Thats huge, for some reason add to cart field freaks out when the nodes have attachments by webfm.

andremolnar’s picture

andremolnar commented
Status: Active » Fixed

I'm going to set this to 'fixed' for now as it is unlikely webfm related. But, in the event you find it is in some way related, please re-open the issue.

andre

tom-d’s picture

tom-d commented

Strangely enough the new 5.x-2.9 has fixed the slow down, whatever you did it worked!

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.