List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:July 28 1999 10:01pm
Subject:Re: Query takes forever!
View as plain text  
Bryan Porter wrote:
> 
> Greetings All :
> 
> Anyone know why this query takes forever? Literally, like 10 minutes, and
> then it give an 'Out of Memory' error. Anyone know what the deal is?
> 
> select s.date_received, s.hard_drive, s.image_path, s.location, s.memory,
> s.misc_info, s.missing_part
> s, s.os, s.price, s.processed, s.processed_by, s.processor_type,
> s.receiver, s.received_recon, s.reference,
> s.repair_cost, s.audit_date, s.case, s.condition, s.cost, s.cpu_speed,
> s.customer, s.date_processed, s.retai
> l, s.serial_number, s.size, s.y2k_compliant, s.unique_number, s.system_id,
> s.sold_to, s.sold, s.type, s.skid
> _num, s.receiver_finished, m.manufacturer, c.cdrom_speed, mm.modem_speed,
> sc.sndcrd_name, mo.model, s.repair
> s_req, s.size FROM tblSystems s, tblManufacturer m, tblCdrom c, tblModems
> mm, tblSoundCards sc, tblModel mo
> WHERE id = 1123 AND (s.manufacturer_id = m.manufacturer_id OR s.cdrom_id =
> c.cdrom_id OR s.modem_id = mm.mod
> em_id OR s.soundcard_id = sc.soundcard_id OR s.model_id = mo.model_id)
> 
> Regards,
> Bryan Porter
> Programmer/Analyst
> 
> Executive Personal Computers, Inc.
> Ph: 209.1999
> Fx: 209.1998
> 

This is a heck of a query!!! :-) 

Can you do EXPLAIN on the query and DESCRIBE on the tables?

-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
Thread
Query takes forever!Bryan Porter29 Jul
  • Re: Query takes forever!Sasha Pachev29 Jul
  • RE: Query takes forever!jim.cistaro29 Jul