Widget array contains 260k+ items causing severe performance issues [#1095878]

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

Comment #1

quicksketch

he/him

commented 18 March 2011 at 15:41

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?

Comment #2

budda

English

Cheshire

commented 21 March 2011 at 10:57

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

Comment #3

budda

English

Cheshire

commented 21 March 2011 at 11:02

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

Comment #4

mikebell_ commented 21 March 2011 at 13:58

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

Comment #5

lpalgarvio commented 21 March 2011 at 23:57

got the same issue with insert module.

Comment #6

budda

English

Cheshire

commented 24 March 2011 at 17:26

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.