I am facing issue with Product Add page and Product Edit Paga with nopcommerce.I debug the code and found issue with following code.
File:SpecificationAttributeService
public virtual IList<SpecificationAttributeOption> GetSpecificationAttributeOptionsBySpecificationAttribute(int specificationAttributeId)
{
var query = from sao in _specificationAttributeOptionRepository.Table
orderby sao.DisplayOrder
where sao.SpecificationAttributeId == specificationAttributeId
select sao;
var specificationAttributeOptions = query.ToList();/// he My Server is taking time.
return specificationAttributeOptions;
}