Better way to get player statistics?

[Azimkin]

Hi there, I have tried to get player statistics from PLAN? but realized that my way is EXTREMELY slow (30-100s for query). I wrote this code a few month ago, after some research in source code of the plugin. Could you please help me resolve these speed issues.

public class PlanActivityProvider implements PlayTimeProvider, SessionsProvider {
    @Override
    public long getActivePlayTime(String nickname, long from, long to) {
        val uuid = Bukkit.getOfflinePlayer(nickname).getUniqueId();
        var playerContainer = PlanUtils.getDatabase().getDatabase().query(new PlayerContainerQuery(uuid));
        var sessionsMutator = SessionsMutator.forContainer(playerContainer);
        var mutator = sessionsMutator.filterSessionsBetween(from, to);
        return mutator.toActivePlaytime();
    }

    @Override
    public long getPlayTime(String nickname, long from, long to) {
        val uuid = Bukkit.getOfflinePlayer(nickname).getUniqueId();
        var playerContainer = PlanUtils.getDatabase().getDatabase().query(new PlayerContainerQuery(uuid));
        var sessionsMutator = SessionsMutator.forContainer(playerContainer);
        var mutator = sessionsMutator.filterSessionsBetween(from, to);
        return mutator.toPlaytime();
    }

    @Override
    public int getSessionsCount(String nickname) {
        val uuid = Bukkit.getOfflinePlayer(nickname).getUniqueId();
        var playerContainer = PlanUtils.getDatabase().getDatabase().query(new PlayerContainerQuery(uuid));
        var sessionsMutator = SessionsMutator.forContainer(playerContainer);
        return sessionsMutator.count();
    }
}

[AuroraLS3]

You should use Query API and SQL aggregation functions (SUM(session_end-session_start) as playtime, SUM(session_end-session_start-afk_time) as active_playtime, COUNT(*) directly against plan_sessions table. The player container query fetches all sessions as individual items into memory so that could be one reason.

https://github.com/plan-player-analytics/Plan/wiki/APIv5-Query-API
https://github.com/plan-player-analytics/Plan/wiki/Database-Schema

[Azimkin]

Thanks for the reply. I rewrote my old code with direct SQL, but then realized that every database request from PLAN is sync and will be performed sequently (no diff whether its query or execute). Now I will try to use my own connection pool for async execution if there is no other way to do it.