If I use localhost - XAMPP, my application runs without problems. Once I try to use real MySQL databases: db4free.net, freedb.tech. Applications begins to choke and freezing, resulting it is nearly impossible to use.
If I choose to use paid MySQL database, will it solve problem?
public static void scanningPlayers ()
{
updatePlayers.setNode( GameGroups.finalRoot); // does'nt matter node.
updatePlayers.setDuration(Duration.millis(1000));
updatePlayers.play();
updatePlayers.setOnFinished(evt ->
{
GameGroups.rootPlayers.getChildren().clear();
try
{
Statement stmt = Credentials.conn.createStatement();
ResultSet users = stmt.executeQuery("select id, name, avatar, Xpos, Ypos from users");
while ( users.next() )
{
Label playerName = Default.Label17Light ( "" + users.getString("name"), users.getInt("Xpos"), users.getInt("Ypos") - 25 );
ImageView hero;
hero = Default.ImageView( Dir.adventure + users.getString("avatar") + ".png", users.getInt("Xpos"), users.getInt("Ypos") );
GameGroups.rootPlayers.getChildren().addAll ( playerName, hero );
if ( users.getInt("id") == Variables.id )
{ //identify mysel, used for centering n door.
Variables.Xpos = users.getInt("Xpos");
Variables.Ypos = users.getInt("Ypos");
Variables.myAvatar = hero;
GameGroups.rootUniverse.setTranslateX ( -Variables.Xpos + 550);
GameGroups.rootUniverse.setTranslateY ( -Variables.Ypos + 362);
}
}
} catch (SQLException e) {e.printStackTrace(); }
updatePlayers.play();
});
}