Page 1 of 1
connecting to database is too slow
Posted: Tue 27 May 2008 10:09
by charbel
when trying to connecting to database and then open tables , its taking about 6-7 seconds to connect to the database , how could i speed it.
on form create event, im connecting to the database :
MasterDB.Connected:=true;
note that im using InnoDB engine ,Delphi2006 and MyDac 5.20.1.15
Posted: Wed 28 May 2008 07:54
by jkuiper_them
If your using the MySQL browser tool from MySQL, do you have the same problems
Posted: Wed 28 May 2008 08:17
by charbel
im connecting to the database through network. while using the MySQl query browser, its also taking time to fetch for the tables to display.
Posted: Wed 28 May 2008 10:12
by jkuiper_them
There's a different on fetching the tables or doing a select on a table.
If there a lot tables to display, it could take seconds. But it doesn't tell you about the connection.
If your doing a select in MySQL browser, does it take a time to get a result back? When do you notice that your connection is slow: on an entire table or a query?