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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]