Sql_big_selects=1

[Shadowgrave]

Hi all

I'm trying to run a SQL query for my website but I'm getting this message:

#1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

I've looked around the web but can't seem to find what I'm ment to do here. Can anyone give me some hints please?

Thanks in advance for any help.

[coldhead]

show us your select statement.

[Shadowgrave]

Select
eve_names.itemName,
eve_agents.level,
eve_agents.quality,
eve_divisions.divisionName,
eve_regions.regionName,
eve_stations.stationName
From
eve_names
Left Join eve_agents ON eve_agents.agentID = eve_names.itemID
Inner Join eve_stations ON eve_agents.stationID = eve_stations.stationID
Inner Join eve_regions ON eve_stations.regionID = eve_regions.regionID
Inner Join eve_divisions ON eve_divisions.divisionID = eve_agents.divisionID
Where
eve_names.itemName LIKE '$agn%%'
Order By
eve_names.itemName Asc

[Shadowgrave]

Ok, I found the answer to my question.

[IanS]

Can you share it so that others with a similar problem in future can solve their issue?

[Shadowgrave]

Ok. The tables I'm using for this are fairly large (56,000 records in one, 38,000 in another, etc, etc), so if you're using small tables you should never need this.

Here is the statement I'm using to pull the data now.

<?php
if(isset($agn))
{
{
mysql_query("set sql_big_selects=1");
$sqlstring = "SELECT eve_names.itemName AS enin, eve_agents.level AS eal, eve_agents.quality AS eaq, eve_regions.regionName AS errn, eve_stations.stationName AS essn, eve_divisions.divisionName AS eddn FROM eve_names";
$sqlstring .= " Join eve_agents ON eve_agents.agentID = eve_names.itemID";
$sqlstring .= " Join eve_stations ON eve_agents.stationID = eve_stations.stationID";
$sqlstring .= " Join eve_regions ON eve_stations.regionID = eve_regions.regionID";
$sqlstring .= " Join eve_divisions ON eve_divisions.divisionID = eve_agents.divisionID";
$sqlstring .= " WHERE eve_names.itemName LIKE '$agn%%'";
$sqlstring .= " AND eve_regions.regionName LIKE '$agr%%'";
$sqlstring .= " AND eve_names.categoryID='1'";
$sqlstring .= " ORDER BY eve_names.itemName";
$result = mysql_query($sqlstring, $db);
}
}
?>

Where mysql_query is the name of the query you are using.

I hope that helps.

[IanS]

Thank you for sharing - that is the purpose of these forums.