In the last episode (Dec 18), Markus Fischer said: > On Tue, Dec 16, 2003 at 10:38:14AM -0600, Dan Nelson wrote : > > Raising sort_buffer_size and join_buffer_size may also help if your > > queries pull a lot of records. > > From what I read from the manual, sort_buffer_size is only used > for the isamchk tools, isn't it? I've adapted join_buffer_size > though; thanks.
It's used for any sorting: * `sort_buffer_size' Each thread that needs to do a sort allocates a buffer of this size. Increase this value for faster `ORDER BY' or `GROUP BY' operations. *Note Temporary files::. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]