i have a table in my mysql database with around 66 million rows in it.� when i query this table, it takes anywhere from 3 minutes to 10 minutes to return the results.� i've tried this both from within the mysql command line and from java programs.
Perhaps telling us what the query is might help with a solution. Adding the proper index might speed things up dramatically; sometimes re-wording the query can also help.
___/
/
__/
/
____/
Ed Leafe
http://leafe.com/
http://opentech.leafe.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
