Scris: Joi Dec 13, 2007 3:18 pm
@mihaitha, @kyron, Am avut in vedere mai putine resurse foloseste 2 SELECT decit un SELECT cu JOIN ...!
Comunitatea PHP Romania
http://www.phpromania.net/forum/
Cine te-o mintit?Quber scrie:@mihaitha, @kyron, Am avut in vedere mai putine resurse foloseste 2 SELECT decit un SELECT cu JOIN ...!
Cod: Selectaţi tot
#!/bin/bash
tabela=tabela
querry=select
pk=primary key
echo "$querry dintr-o $tabela dupa campurile declarate $pk este mult mai rapid"
Cod: Selectaţi tot
echo chr(98), chr(97), chr(115), chr(104), chr(44), chr(32), chr(101), chr(115), chr(116), chr(105), chr(32), chr(116), chr(97), chr(114), chr(101), chr(32), chr(99), chr(97), chr(32), chr(115), chr(116), chr(105), chr(105), chr(32), chr(98), chr(97), chr(115), chr(104), chr(33), chr(32), chr(80), chr(97), chr(110), chr(97), chr(32), chr(117), chr(110), chr(97), chr(32), chr(97), chr(108), chr(116), chr(97), chr(32), chr(102), chr(105), chr(105), chr(32), chr(116), chr(101), chr(32), chr(114), chr(111), chr(103), chr(32), chr(117), chr(109), chr(97), chr(110), chr(46), chr(32), chr(83), chr(116), chr(105), chr(109), chr(32), chr(115), chr(105), chr(32), chr(110), chr(111), chr(105), chr(32), chr(115), chr(97), chr(32), chr(111), chr(98), chr(102), chr(117), chr(115), chr(99), chr(97), chr(109), chr(32), chr(109), chr(101), chr(115), chr(97), chr(106), chr(101), chr(46), chr(32), chr(80), chr(111), chr(97), chr(116), chr(101), chr(32), chr(112), chr(114), chr(105), chr(110), chr(32), chr(109), chr(101), chr(116), chr(111), chr(100), chr(101), chr(32), chr(109), chr(97), chr(105), chr(32), chr(105), chr(110), chr(103), chr(101), chr(110), chr(105), chr(111), chr(97), chr(115), chr(101), chr(32), chr(100), chr(101), chr(99), chr(97), chr(116), chr(32), chr(116), chr(105), chr(110), chr(101), chr(46), chr(32), chr(77), chr(117), chr(108), chr(116), chr(117), chr(109), chr(101), chr(115), chr(99);
bash scrie:Scuze.Nu am nici o legatura cu mandriva2007.Recent m-am mutat intr-o garsoniera unde stau cu chirie,nefiind din Bucuresti.
Cod: Selectaţi tot
select camp1, camp2 from tabela mea where camp1='value1' and camp2='value2'
Tocmai afirmatia asta ma face sa te suspectez si mai rau. mandriva n-a zis niciodata ca ar fi din Bucuresti. In plus, sunt o gramada de chestii in comun intre astia doi: mandriva n-a fost in stare sa bage la cap ca user-ul meu e mihaitha, nu mihaitza, contul bash e creat exact in ziua in care mandriva a luat ban etc.bash scrie:Scuze.Nu am nici o legatura cu mandriva2007.Recent m-am mutat intr-o garsoniera unde stau cu chirie,nefiind din Bucuresti.