Hi,

I have a question regarding speed of the query.
In my application i am useing Mysql 4.0.20a-nt.
I have 10 tables and each table contains 4000000 records
and also 61 columns. I already created indexs on six column which are
important for me.

i fired the query on tables through servlet(thread).
I fired same query on all tables on same time, but it has take time to
getting result . allmost
7 to 10 minute .

so please tell me 
how can i imporve speed of the Mysql or query?

so it will take less time !

Thanks 
Shailendra

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to