connecting to database is too slow

charbel · Post by **charbel** » Tue 27 May 2008 10:09

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

jkuiper_them · Post by **jkuiper_them** » Wed 28 May 2008 07:54

If your using the MySQL browser tool from MySQL, do you have the same problems

charbel · Post by **charbel** » Wed 28 May 2008 08:17

im connecting to the database through network. while using the MySQl query browser, its also taking time to fetch for the tables to display.

jkuiper_them · Post by **jkuiper_them** » Wed 28 May 2008 10:12

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?