This query took 1min 18 sec on a Pentium 90 with 64Meg. Sort of surprised
me. Should I have been surprised? (v6.2.1 + patches)
select address1, a.loc_name, b.loc_name, c.loc_name, d.loc_name,
e.loc_name, f.loc_name from property, location a ,
location b, location c, location d, location e,
location f where
livrm_loc=a.loc_code and dinrm_loc=b.loc_code and
breaknook_loc=c.loc_code and masterbed_loc=d.loc_code and
famrm_loc=e.loc_code and greatrm_loc=f.loc_code ;
location is a table that contains 5 rows:
loc_code|loc_name
--------+-----------
B |Basement
E |Entry Level
U |Upper Level
N |N/A
|Unknown
(5 rows)
property is a table that contains 33 rows.
Marc Zuckman
marc@fallon.classyad.com
_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
_ Visit The Home and Condo MarketPlace _
_ http://www.ClassyAd.com _
_ _
_ FREE basic property listings/advertisements and searches. _
_ _
_ Try our premium, yet inexpensive services for a real _
_ selling or buying edge! _
_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
