* DeRyl > I have database with 30 tables [some have over 2000k some other > over 4000k rec] > > when I want to run a sql with a few conditions the answer is > dramatically slow > [over 70 seconds!] > sql-s with one condition usually works well.. > > how is the corrcet way to optimize the database and sql questions? > the answer from sql should be under 1 second...
I agree. For a start, show us the output of EXPLAIN select distinct logo, klient.klientid ... Then we will probably need the output of SHOW CREATE TABLE for some of the tables, depending on the output of the EXPLAIN command. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
