I wrote a fighting game in JavaFX, using JDBC to update information into a MySQL database. Most tasks that get basic information from the database server work fine if they are not repeated continuously. The problem arises when I need the program to constantly update the opponent's information, such as position, level, damage, etc. in the game. I have to constantly send select commands to the server, which increases the RAM used by the thread running these commands.

void startUpdatingOpponentInfo() {
    Thread thread = new Thread(() -> {
        while (matchID != -1) {
            String query = String.format("select * from matchDetails where matchID = %d and userID = %d", matchID, opponentID);
            try {
                ResultSet resultSet = sqlConnection.getDataQuery(query);
                while (resultSet.next()) {
                    double opponentX = resultSet.getDouble("xPos");
                    double opponentY = resultSet.getDouble("YPos");
                    if (opponentX != -1 && opponentY != -1)
                        opponent.move(canvas, new Position(opponentX, opponentY));
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
            try {
                Thread.sleep(10);
            } catch (InterruptedException e) {
                throw new RuntimeException(e);
            }
        }
    });
}

  public ResultSet getDataQuery(String query) {
    Statement statement;
    ResultSet resultSet = null;
    try {
        statement = connection.createStatement();
        resultSet = statement.executeQuery(query);
    } catch (SQLException e) {
        System.out.println(query);
        e.printStackTrace();
    }
    return resultSet;
}

I tried searching for some methods and found a very useful method. After each select, I let the thread sleep for a while before making another select. This approach significantly improves performance and RAM consumption remains stable. However, this approach is not suitable for query information that needs to be refreshed all the time, because the short sleep of the "select" thread will still cause high RAM consumption. Is there any useful way to solve this problem and let my game connect directly to the database server without going through the intermediate game server.