In the last episode (Feb 07), [EMAIL PROTECTED] said:
> I just stumbled on this hard to explain problem. Below
>
> select * from BigTable (BigTable has 5 million rows)
>
> takes forever to even print out the first row. as you could see from
> the sql, it is supposed to print out some rows right away regardless
> of server config in my.cnf. What is interesting is the following
> sql
>
> select * from BigTable limit 1000
>
> return the rows immediately as expected.
You want the --quick option. From the mysql manpage:
o --quick, -q
Do not cache each query result, print each row as it is
received. This may slow down the server if the output is
suspended. With this option, mysql does not use the history
file.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
