I'm working with Mysql Control Center 0.9.2-Beta that contains tables with
almost 15,000 records. I have coded complicated queries which will really
return thousands of records. My queries goes fine but one day i had encountered
an error 1104:
[marketing] ERROR 1104: The SELECT would examine more rows than MAX_JOIN_SIZE.
Check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if
the SELECT is ok.
I have surfed the net regarding this topic and surprisingly i'm not the only
one. This is really complicated for me because i left the program working. When
i ran it one day...my VB6 program doesn't respond anymore. i tried this query
directly into MYSQL sql pane, then the error had shown.
Could uploading table from MS Access 97 would come up with this problem? Did my
settings have been altered? I'm a little bit confused about this.
My Mysql Options are indicated here:
Automatic LIMIT Select Queries to : 1000
Net Buffer Lenght: 16384
Maximum Allowed Packet: 16777216
Maximum Join Size: 1000000
my max_join_size is 4294967295
if there's something wrong in my settings please give me advice.
By the way, I have already done SET SQL_BIG_SELECTS=1; and typed my query. It
works! But it's not permanent....it's not effective anymore if the session
ends. I did that also for other queries with thousands of results, but it takes
too long that it wasn't that supposed to be like that. I don't know what's
wrong. It works in MS Access 97. I'm desperate. Anyone please help. Thanks in
Advance.
---------------------------------
Yahoo! Messenger - Communicate instantly..."Ping" your friends today!
Download Messenger Now
[Non-text portions of this message have been removed]
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [email protected]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
