1 Topic by Plx (edited by Plx 2008-12-26 21:36:45)

  • Plx
  • Member
  • Offline
  • From: Telšiai
  • Registered: 2008-12-26
  • Posts: 8

Topic: Ar imanoma kazka cia optimizuot?

Taip nutiko, kad reikia padaryt el. parduotuve :)

Susiduriau su problema, mat mano nedidelios mysql zinos nezino, ar imanoma kaip nors optimizuot sia veiksmu eile:

$buvo = mysql_query("SELECT prekes_id, kiekis FROM krepselis WHERE id='{$info[$i]}'");
$id = mysql_result($buvo, 0, 0);
$kiekis = mysql_result($buvo, 0, 1);
$ok = mysql_query("UPDATE prekes SET kiekis=kiekis+{$kiekis} WHERE id='{$id}'");
if ($ok)
    mysql_query("DELETE FROM krepselis WHERE id='{$info[$i]}'");

Atrodo, kad 3 uzklausos nedaug, taciau gali buti taip, kad sis kodas bus prasuktas ~10-50 kartu vienu metu, o tai jau yra tikrai neoptimalu.

Plx's Website

  • SpX
  • Member
  • Offline
  • Registered: 2007-11-11
  • Posts: 40

Re: Ar imanoma kazka cia optimizuot?

kiek ten milijonu lankytoju ? :) beje, jei nezinai ar galima optimaliau, tai kodel manai kad cia gali buti "neoptimalu" :)

  • Plx
  • Member
  • Offline
  • From: Telšiai
  • Registered: 2008-12-26
  • Posts: 8

Re: Ar imanoma kazka cia optimizuot?

SpX wrote:

kiek ten milijonu lankytoju ? :) beje, jei nezinai ar galima optimaliau, tai kodel manai kad cia gali buti "neoptimalu" :)

Kiek lankytoju nesvarbu, pikti dedes gali suzinoje apie sia 'silpna' vieta gerokai pakankinti serveri, ir isnaudoti valandinius limitus :)

Plx's Website

4 Reply by SpX (edited by SpX 2008-12-27 21:16:36)

  • SpX
  • Member
  • Offline
  • Registered: 2007-11-11
  • Posts: 40

Re: Ar imanoma kazka cia optimizuot?

mysql_query("

UPDATE prekes SET prekes.kiekis = prekes.kiekis + krepselis.kiekis
INNER JOIN kapselis ON ( prekes.id = krepselis.prekes_id )
WHERE krepselis.id = "{$info[$i]}";

");

mysql_query("DELETE FROM krepselis WHERE id='{$info[$i]}'");

© pasigydziau

beje, kas tas $info ? :)

  • From: Vilnius
  • Registered: 2008-06-11
  • Posts: 1,254

Re: Ar imanoma kazka cia optimizuot?

e-parduotuve ant servo su valandiniais resursais ? :D

MongoDB Certified Developer
MongoDB Certified DBA
Zend Certified Engineer

Warning: count(): Parameter must be an array or an object that implements Countable in /home/pasokime/domains/mysql.lt/public_html/forumas/include/parser.php on line 820
  • Registered: 2007-01-08
  • Posts: 256

Re: Ar imanoma kazka cia optimizuot?

be to, nevisa viena užklausa yra optimaliau

agonija - http://www.agonija.eu
neworld - http://www.neworldwar.com
neuron  - http://neuron.avita.lt