Mysql slowing down my application
- by user2985991
my application is taking ages to load because of my database isnt located on my computer.. Anyone have any idea to how improve my performance?
public Form1()
{
Splash splash = new Splash();
splash.Show();
InitializeComponent();
Load();
public void Load()
{
db.SelectTeam();
db.SelectMatches();
}
On db.SelectTeam and SelectMatches I get everything I need from mysql and put into lists...
Sorry if it's confusing, but I don't know what to do, and sorry for my bad english
EDIT:
Here are the querys
string query = "SELECT * FROM teams ORDER BY name";
string query = "SELECT * FROM matches ORDER BY date ASC";