| Mailing List | | Home | | MySQL General - General MySQL discussion | | MaxDB - Everything about MaxDB, formerly known as SAP DB | | MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP | | Java Help - Mostly related to the MySQL Connector/J driver | | ODBC - ODBC with the MySQL Connector/ODBC driver | | Perl - Perl support for MySQL with DBI and DBD::mysql | | MySQL++ - Programming with the C++ API to MySQL |
|
|
  | |  Re: MySQL takes 8Sek, MySQLcc takes 0.1Sek to run the same query.
WHY??? | Re: MySQL takes 8Sek, MySQLcc takes 0.1Sek to run the same query.
WHY??? 2004-03-15 - By T Cunningham
Back 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/mysql?unsub=mysql
@(protected)
|
|
 |