fbpx
  Monday, 31 August 2020
  4 Replies
  3.6K Visits
  Subscribe
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
4 years ago
·
#5090
Hey,

Thank You for the suggestion. I will forward this to the team. If your issue is resolved please mark this post as resolved.
4 years ago
·
#5007
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.
4 years ago
·
#5003
Thank you
4 years ago
·
#4997
Hello,

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
  • 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