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

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?

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

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

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

+1

got the same issue with insert module.

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.

Title:widget array contains 260k+ items causing severe performance issues.Widget array contains 260k+ items causing severe performance issues

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

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.