MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:October 20 2005 6:25pm
Subject:Re: Temp tables
View as plain text  
Hello.

> Is there anything I can do to get this query to run - is there a size
> limit for the temp tables that can be tweaked?

Have a look here:
  http://dev.mysql.com/doc/refman/5.0/en/full-table.html



Erich C. Beyrent wrote:
> Hi all,
> 
> I am running into a brick wall with a query that is running against a
> MySQL 3x database, and the temp tables are filling up before the query
> can run.
> 
> Here is the query:
> 
> SELECT
>     Avails.ResortID,
>     Inventory.ID as InventoryID,
>     Avails.ID as AvailabilityID,
>     DATE_FORMAT(Avails.OpenWhen, '%c/%d/%Y') as OpenWhen,
>     Avails.Cost,
>     Inventory.Name,
>     Inventory.Capacity,
>     Inventory.Beds,
>     Inventory.Baths,
>     ResortSpecials.RequiresTour
> FROM
>     Inventory,
>     Avails,
>     ResortSpecials
> WHERE
>     Avails.InvID = Inventory.ID AND
>     Inventory.Activated = 'Y' AND
>     Inventory.PromotionID = ResortSpecials.ID AND
>     ResortSpecials.RequiresTour = 'N' AND
>     Avails.OpenWhen > NOW() AND
>            (Avails.StatusCode = 'GREEN' OR
>             Avails.StatusCode = 'YELLOW')
> ORDER BY
>            Avails.ResortID,
>           Avails.InvID,
>            Avails.OpenWhen;
> 
> 
> 
> Is there anything I can do to get this query to run - is there a size
> limit for the temp tables that can be tweaked?
> 
> I am sure I can do the sorting in PHP if that will help the situation...
> 
> -Erich-
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



Thread
Temp tablesErich C. Beyrent20 Oct
  • Re: Temp tablesGleb Paharenko21 Oct