List:General Discussion« Previous MessageNext Message »
From:Leo Date:November 11 2003 1:16am
Subject:Re: Complex query woes
View as plain text  
hi Steffan,

i already email you about the null result,
it should be eliminated with a where statement (not including null value)

and about the long time it took,
maybe you shuld add some index to your table...

i suggest

alter table customer add index parents (pid);
alter table customer add index my_id (id);

-leo-
  ----- Original Message ----- 
  From: Steffan A. Cline 
  To: Leo ; mysql@stripped 
  Sent: Monday, November 10, 2003 8:12 PM
  Subject: Re: Complex query woes


  Leo,

      Thanks for the quick reply. There was a typo but I fixed it. Below is
  what I used after correcting it :

  select mgr.company, building.bldgname, tenant.id from customers mgr left
  join customers building on building.pid=mgr.id left join customers tenant on
  tenant.pid=building.id group by mgr.id, building.id, tenant.id order by
  mgr.company, building.bldgname, tenant.company;

  This was closer. Problem now is that it took 6.56 seconds and returned 610
  rows. I have no idea how I now have 610 rows where there are only 279. Any
  thing else you would suggest?




  Thanks

  Steffan

  ---------------------------------------------------------------
  T E L  6 0 2 . 5 7 9 . 4 2 3 0 | F A X  6 0 2 . 9 7 1 . 1 6 9 4
  Steffan A. Cline
  Steffan@stripped                             Phoenix, Az
  http://www.ExecuChoice.net                                  USA
  AIM : SteffanC          ICQ : 57234309
  The Executive's Choice in Lasso driven Internet Applications
                                    Lasso Partner Alliance Member
  ---------------------------------------------------------------


Thread
Complex query woesSteffan A. Cline10 Nov
  • Re: Complex query woesLeo10 Nov
    • Subqueries in version 4.1Wouter Coppieters10 Nov
      • Re: Subqueries in version 4.1Egor Egorov10 Nov
    • Re: Complex query woesSteffan A. Cline10 Nov
      • query problemBusiness A2Z10 Nov
      • Re: Complex query woesLeo11 Nov