I have a content type which has entity reference mostly. I have also used "field_collection" module to add a entity reference group as cck field with unlimited adding option. A content with small number of this entity group field works fine. But when I add around 100 entity reference group, it can not be viewed or edited. the page keeps loading and returns server error after a long while. sometimes it returns "mysql server stops responding".
any suggestion will be appreciated.
I am using a custom importer module to create content from excel file.