Monday, 31 August 2020
  4 Replies
  3.1K Visits
The opening time of the backend (admin view) is very long.
I counted 15 seconds.

I analyzed the MySQL process during this phase and I found a lot of queries like this:

SELECT SUM(a.hits) AS page_count FROM `#_sellacious_utm_links` AS `a` WHERE a.created >= '2020-08-20 00:00:00' AND a.created <= '2020-08-20 23:59:59'

I created this index:

ALTER TABLE `#_sellacious_utm_links` ADD INDEX(`created`);

but the opening time is not changed

No problem for sellers view because I can hide the Daily Page Views panel
3 years ago

We have forwarded this to our tech team, and they are looking for a solution. However, you can disable the plugin System - Sellacious User Tracking and empty the UTM tables.

I hope this helps.

Thank You & Stay Safe
3 years ago
Thank you
3 years ago
For your information, after that I truncated #_sellacious_utm and #_sellacious_utm_links and disabled the plugin Sellacious User Tracking, also the frontend sped up a lot.

I recommend that you leave them disabled by default.
3 years ago

Thank You for the suggestion. I will forward this to the team. If your issue is resolved please mark this post as resolved.
  • Page :
  • 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
  • +1 (408) 821-8283
  • Email hello@sellacious.com