MySQL Forums :: PHP :: PHPMYADMIN hangs on this query!.HELP!!!!


Advanced Search

PHPMYADMIN hangs on this query!.HELP!!!!
Posted by: poker king ()
Date: March 30, 2009 05:32PM

Ok i am searching for tags in tag table. Rows in the tag table are 14000 records.

1.SELECT * FROM `se_media` WHERE se_media.media_id IN ( SELECT DISTINCT tag_object_id FROM se_phototags WHERE tag_name IN ('cat') )

2.SELECT * FROM `se_media` WHERE se_media.media_id IN ( 34354,35396 )

1. Hangs
2. Works.

SELECT DISTINCT tag_object_id FROM se_phototags WHERE tag_name IN ('cat') returns
34354,35396 in .0001 sec

But 2nd one increases select statement length if the matches are 100000 tags.

I try to join tables i got

#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 am not sure what this do. Is there any optimum value?. why default values do not work?.

Can't you join 6 tables of medium size of (10000 rows?)

Your help is very much appreciated.



Edited 2 time(s). Last edit at 03/30/2009 06:22PM by poker king.

Options: ReplyQuote


Subject Written By Posted
PHPMYADMIN hangs on this query!.HELP!!!! poker king 03/30/2009 05:32PM
Re: PHPMYADMIN hangs on this query!.HELP!!!! Peter Brawley 03/31/2009 12:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.