Re: MySQL takes 8Sek, MySQLcc takes 0.1Sek to run the same query. WHY???

[T Cunningham]

MySQL puts an automatic limit of 1000 on all select queries. Try adding 
"LIMIT 1000000000", and perhaps then it will take a good long time like 
you want.

Tom.

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