Re: Same / Different databases

Our own experiance with this shows that the performance hit joining across is not noticible to users, though we were mostly referencing small static tables. Views seem to crawl though, thats on 7.31.UC4 on AIX 4.3.3ML4 brett Dirk Moolman wrote: > > I have 2 tables: tableA, tableB > > 1st case: tableA and tableB are in the same database and I run a select > which joins the 2 tables. > > 2nd case: tableA is in one database and tableB in another database and I > run the same select which joins the 2 tables. > > Will there be a difference in performance in these 2 cases ? And will this > put extra strain on the server so that overall performance is affected ? > > Dirk Moolman > Database Administrator > Reach Technologies > > "Bravery is the capacity to perform properly even when scared half to > death." > - General Omar Bradley -- ----------------------------------------------------------------- Brett's 11th law of UNIX administration... Users think that Y2K was a non-event... well... They havn't got our overtime bills yet :) ----------------------------------------------------------------- Brett Geer - UNIX Admin/Analyst/Programmer - Intratex Holdings. Tel. +27 31 717 4000 Direct. +27 31 717 4146 Fax. +27 31 717 4001 ----------------------------------------------------------------- The little voices are talking to me again, telling me to reach for a keyboard and type rm -rf /* last week they had me rm -rf `echo $MANPATH | sed 's/:/ /g'` now I fear I have no answers -----------------------------------------------------------------