Hi Guys

We have a Drupal 6 install on the local intranet with Web Links 2.3 - performance in Drupal in general is fine, but the page of Web Links takes up to a minute to load.

There are just over 600 entries in the weblinks table, in around 100 groups. Table stats for weblinks:

Data 112.0 KiB
Index 65,536 B
Total 176.0 KiB

Web Links is the only module in the Web Links module set that is enabled (no links checker).

I installed CacheRouter, but it doesn't seem to have helped much.

Is there anything we can do to improve performance?

Thanks

-Luke

CommentFileSizeAuthor
#3 Weblinks debug info.txt555.71 KBMagilla
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

NancyDru’s picture

Status: Active » Postponed (maintainer needs more info)

My first guess is that you are using IE (maybe 7), which is the slowest browser to load. Test it in Chrome (the fastest). That's alot of stuff to render on one page. You can also install Devel and enable the page render timing. I am going to guess it will be small compared to the time it takes to show up on your screen.

Magilla’s picture

Load time in Chrome is above 40 seconds. I'll go looking for the Devel module, and get back to you.

Thanks

Magilla’s picture

FileSize
555.71 KB

Ok, Devel is on, and the vital stats are:

Executed 10181 queries in 34911.06 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 39805.01 ms.

The full log is attached.

Magilla’s picture

Status: Postponed (maintainer needs more info) » Active

Any ideas?

NancyDru’s picture

Well, 3.43 milliseconds per query sounds pretty decent to me. But you say there are 600 links, so where did the other 10,500 queries come from? Two things I see that look worth looking into: 1) why is the book module active while WL is running? 2) What is the Section module and why is it issuing so many queries (1849) and doing it slowly (20-30 ms each)?

My first suggestion is to open an issue with the Sections module and get them to tune up or cache the "_sections_in_section" function; it is averaging between 22 and 30 ms per query and doing several queries per Web Link node.

Also, if you can talk yourself out of using the Statistics module, you will improve performance with a single click.

Magilla’s picture

Thanks, Nancy.

I've disabled Statistics, and along with disabling "Sections", it brings the page execution time down to 15 seconds instead of 35. I'll take the Sections issue up with them. Why the book module is running during page load, I have no idea.

Edit: new issue for Sections created here: http://drupal.org/node/1110096

NancyDru’s picture

57% reduction ain't too bad.

I doubt you will be able to get below about 3 seconds because of the number of links. And that would be on a completely vanilla system. You just need to go through the Devel report and question everything. There are many modules that would do well to use static variables, but don't.

OhioDave’s picture

I am having similar issues but also getting 500 Server Error and timeouts.

I plan on having 10-15k links on my site.... Is this module/my server going to be able to handle this amount of links?

I looked for the setting to redirect to another node, but cannot find it in 2.3. I am thinking that if I could redirect to /weblinks/add
that this would not take so long by not loading the entire Weblinks page (but again....Im a noob :) )

NancyDru’s picture

10,000 links is far more than the vision for this module. Based on Magilla's report on 600 links, I am concerned. But remember that even if the module handles it, does the user's browser and connection? I doubt a dial-up user would ever see your page.

There are ways to segment the links so that you don't throw the whole 10K at them all at once.

OhioDave’s picture

Personally, I would like to disable the /weblinks page...and change the submit to submit and add new

I never want to display all 10k links at the same time, so looking into filtering the taxonomy. I have two basic groups (location and type). The location has about 900 terms in 3 hierarchical levels (region/county/city-village) and one other "link type" (15-20 terms). Eventually, I would like to have a filter all links from x location and y type...might be at the most 100 links if filtered

Any recommendations?

NancyDru’s picture

walker2238’s picture

10,000 links is far more than the vision for this module. Based on Magilla's report on 600 links

That's horrible news.

NancyDru’s picture

The problem is less about Drupal and this module (see #8) than it is how fast your connection can transfer and a browser can display that much data.

Summit’s picture

Hi,
Still in need of what is asked here to be able to redirect /weblinks to something as /weblinks/add or /admin/content/node after pushing submit on a weblink.
Anyone a solution for this please?
EDIT: http://drupal.org/node/679394#comment-5304734. There is a solution, but not on a official install.
greetings, Martijn