Admin PRODUCTS taking forever to load

  • Posts: 22
  • Thank you received: 0
10 years 11 months ago #172380

-- url of the page with the problem -- : wildplanetdesign.com/rgindustries/administrator/
-- HikaShop version -- : 2.3.2
-- Joomla version -- : 3.3.3
-- PHP version -- : 5.3.22
-- Browser(s) name and version -- : Firefox

When I click on "PRODUCTS" in the admin, it takes four to five minutes and usually just times out. This is not acceptable obviously especially since I am about to turn the site over to the clients after having just built it. Can anyone help? We have optimized the database. The front of the site is FAST, even when searching using multiple filters. Thanks in advance.

Please Log in or Create an account to join the conversation.

  • Posts: 26274
  • Thank you received: 4045
  • MODERATOR
10 years 11 months ago #172382

Hi,

I think that your current session is trying to load every products you got in a single page (which is a big amount of data).
The best will be to force the limitation of the number of products in the backend listing.

You can edit the file "administrator/components/com_hikashop/views/product/view.html.php" and replace

		$pageInfo->limit->value = $app->getUserStateFromRequest( $this->paramBase.'.list_limit', 'limit', $app->getCfg('list_limit'), 'int' );
		if(empty($pageInfo->limit->value)) $pageInfo->limit->value = 500;
By
		$pageInfo->limit->value = $app->getUserStateFromRequest( $this->paramBase.'.list_limit', 'limit', $app->getCfg('list_limit'), 'int' );
		if(empty($pageInfo->limit->value) || $pageInfo->limit->value > 100) $pageInfo->limit->value = 100;
I hope it will help.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 22
  • Thank you received: 0
10 years 11 months ago #172435

thank you, I did exactly what you said, and unfortunately the problem still persists. I can't even get the product page to appear. It is timing out after five minutes in my Firefox browser.

Please can you help me figure this issue out? The store is working perfectly in every other way. Is no one else having this issue? We have a very simple setup, only two categories. Thank you in advance

Please Log in or Create an account to join the conversation.

  • Posts: 22
  • Thank you received: 0
10 years 11 months ago #172439

Is there a way that I can hard code it so that just maybe one page comes up in the back end? Or maybe pre-filter it to a very specific type of product? Because once the page loads, everything is normal. Its just getting the page to open is what the problem is. I dont understand why I am the only one having this issue, my store is very simple. I only have one main category with two sub categories.

Please Log in or Create an account to join the conversation.

  • Posts: 26274
  • Thank you received: 4045
  • MODERATOR
10 years 11 months ago #172493

Hi,

The product page or the product listing ?
I have to admit that I am a little bit lost with your explanation now and I don't understand from where the problem could come from (because I don't understand what the problem really is).

Can you please provide us some credentials to see your backend directly ?

Some things are possible using view override but in your case I can't know if it is the solution.. I need to understand first.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 22
  • Thank you received: 0
10 years 11 months ago #172580

Its entirely in the admin. The PRODUCT listing page in the admin. I go to COMPONENTS ---> HIKASHOP , then click on PRODUCTS. It takes a long long time for the products to appear, up to five minutes.

Thanks

Please Log in or Create an account to join the conversation.

  • Posts: 22
  • Thank you received: 0
10 years 11 months ago #172590

Nicolas from Hikashop got into the admin for me and figured out the problem, apparently I dont have enough categories, there are only two categories with 22,000 product in each one, and he said it was because MySQL has to combine the product and the product_category tables before doing the sorting of the listing and that is why it is taking too long to load. He removed the sorting feature on the query and that fixed it, now i cannot sort but at least the products come up within several seconds.

Please Log in or Create an account to join the conversation.

  • Posts: 26274
  • Thank you received: 4045
  • MODERATOR
10 years 11 months ago #172591

Hi,

Thanks for sharing your solution.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

Time to create page: 0.064 seconds
Powered by Kunena Forum