I noticed a huge performance drop in a site that I run, after me and my colleagues digged into the cause we found that the filefield widget array in _content_type_info() contained over 260,000+ blank items. This was then repeated another 2 times in the cache blob.

What could cause all these extra array items? It's causing a huge performance loss and out of memory errors when drupal tries to unserialise the content.

We posted here http://drupal.org/node/1009596 and narrowed it down to filefield.

Any help would be great.

Comments

quicksketch’s picture

I got another issue over in the Insert queue: #1091648: Performance issues - unusual huge mysql row size, unusual huge memory and cpu usage. It doesn't seem like any issue has quite discovered what the actual source of this problem is, though #1009596: _content_type_info() memory usage improvements seems a bit more on track. Do you also have Insert module installed?

budda’s picture

Any idea what these empty widget array items are actually for? (as seen in http://dl.dropbox.com/u/1286874/debug.txt output)

budda’s picture

The Insert module isn't installed on the problematic site.
Only related modules (I think) are: ImageField, FileField Paths.

mikebell_’s picture

Disabling Imagefield and FileField Paths doesn't solve the issue unfortunately.

lpalgarvio’s picture

+1

got the same issue with insert module.

budda’s picture

Version: 6.x-3.9 » 6.x-3.x-dev

Is there any good place to start in debugging this problem? Happy to get stuck in, but if anyone knows the best place to start to save time I'm all ears.

apaderno’s picture

Title: widget array contains 260k+ items causing severe performance issues. » Widget array contains 260k+ items causing severe performance issues
lpalgarvio’s picture

this issue is very serious.
http://drupal.org/node/1091648

quicksketch’s picture

Status: Active » Postponed (maintainer needs more info)

Yes, very serious but I still have no idea how to recreate the problem and I'm not seeing it on any of my sites.

apaderno’s picture

Issue summary: View changes
Status: Postponed (maintainer needs more info) » Closed (outdated)

I am closing this issue, which is for a not supported Drupal version.