UPDATES EasyBlog 6.0.11 Released! Update to the latest version now!

Helpdesk

Your Time
Our Time
Response Time
24 — 48 hours
We strive to provide the fastest ever response possible. However, we are not super beings.

Allow at least 24 — 48 hours
  Support is offline
It is currently off working hours and most of us aren't around

Rest assured that we will get back to you as soon as the day starts tomorrow!
  Support is offline

Add a DB table index to EasySocial

User · ·
10:56 PM Friday, 12 March 2021
Normal
Hello. When I asked server support why does some website pages loads slowly, they say:
You also have many queries running without an index, adding them will greatly reduce the load.


In this topic https://stackideas.com/forums/leader-board-module-and-page-slow-down-website#reply-537053 Sam added a DB table index into `#__social_points_history` and this increased the leaderboard module / leaderboard page query performance.

alter table `#__social_points_history` add index `idx_created` (`created`);


I suppose this pages loads not enough fast:
1. Points Assignment – may be the most slowest page at the moment https://strana-krovi.com/rating
2. All Videos https://strana-krovi.com/videos
3. Dashboard (stream items sort by last modified) https://strana-krovi.com/community
4. All Albums https://strana-krovi.com/photos
5. All members https://strana-krovi.com/badges
6. All badges https://strana-krovi.com/badges (normal load)

Is it possible to add a DB table index by StackIdeas support team?

Or can you teach how to do it? Or may be provide examples of SQL queries? I read few articles about «table index» but it have not a lot examples with Joomla (or EasySocial).

Thanks.
The replies under this section are restricted to logged in users or users with an active subscription with us