Hi, ppl!
I have a MySQL-server on FreeBSD-5.2.1 computer and a client on another computer under windows xp.
I have the following simple query SELECT internal_number,page_no FROM pages WHERE docs=307 ORDER BY page_no
that results in 587 lines with two integers only. Simple query with low output volume
The problem is that if I use a local client on FreeBSD-computer I get the result immediately.
But if I try to do the same via tcp-connection it takes few minutes.
After I used EXPAIN query it turned out that when I use tcp-connection USING FILE SORTING occurs.
How to cure that?
Alex
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
