Login Page: New Products added taking longer time to Load

Login Page: New Products added taking longer time to Load

The portlet - 'New Products Added' available in the login page is meant to view a list of products for last 1 week/1 month etc. We have observed that there were close to 320 Products in the last 1 week. Therefore, the login page is taking longer time to load. The possible ways of addressing this Issue is as follows: a) Disable the portlet on the login page OR b) We can control the count by filtering out (such as displaying products of one group etc.) or using TOP as a key word in the SQL to achieve better performance.