4 messages in com.mysql.lists.gui-toolsRe: v0.9.1: SQL_BIG_SELECTS - still n...
FromSent OnAttachments
Taso Lyristis20 Apr 2003 14:08 
John R Wunderly20 Apr 2003 15:35 
Kevin F. Berrien20 Apr 2003 16:16 
Karam Chand20 Apr 2003 22:40 
Subject:Re: v0.9.1: SQL_BIG_SELECTS - still not working - help?
From:Karam Chand (kara@yahoo.com)
Date:04/20/2003 10:40:43 PM
List:com.mysql.lists.gui-tools

Hello

I would suggest that if you are on Windows, try out SQLyog by Webyog at http://www.webyog.com/sqlyog .

Lot of bugs related to MyCC are not present in this tool.

Karam

--- Taso Lyristis <ta@lyrisoft.com> wrote:

There have been lots of posts about this problem in the list. I have tried the recommended solution, but still have no luck.

Just to be clear, this is recommended solution, as I understood it:

in MySQL Options, set Automatically limit SELECT queries: 10000

in Query Window Options, set SQL_BIG_SELECTS: 1

Having done that, I still consistently get this message when querying a table with more than 1 row: ERROR 1104: The SELECT would examine too many records and probably take a very long time. Check your WHERE and use SET OPTION SQL_BIG_SELECTS=1 if the SELECT is ok

What am I missing here? Is anybody actually running 0.9.1 without this problem? If not, what version should I downgrade to?

Thanks in advance.

- taso

-- MySQL Control Center Mailing List For list archives: http://lists.mysql.com/mysqlcc To unsubscribe: