ricks Posted March 12, 2008 Report Share Posted March 12, 2008 Ir viens db lietotājs, kam ir pieeja vairākām DB. Vai no performances viedokļa ir starpība, vai pirms datu atlases izpildām mysql_select_db(`datu bāze`) vai vnk raxtām kverijos pilno ceļu uz tabulu - SELECT * FROM `datu bāze`.`tabula` ...? Link to comment Share on other sites More sharing options...
Grey_Wolf Posted March 12, 2008 Report Share Posted March 12, 2008 (edited) atrdarbiiba starpiibas nebuus, bet ja buus garsh kverijs ar daudziem JOIN tad buus Ljoti gruuti lasiit.. Piedevam NEVAJAG izmantot SELECT * ... tas ir * , bet gan labak SELECT id, nu to ko vajag ... un tad iedomaajies kaa izskatiisies.. SELECT db.tabula.id, db.tabula.name, db.tabula.niks ... vai tomer labaak saadi SELECT id, name, niks.... --- Izlem pats... P.S. sadi var izmantot ja Javel dati no 2 dazadam DB vienaa kverijaa.. Edited March 12, 2008 by Grey_Wolf Link to comment Share on other sites More sharing options...
nemec Posted March 12, 2008 Report Share Posted March 12, 2008 SELECT t.* FROM `base`.`table` AS t Link to comment Share on other sites More sharing options...
Recommended Posts