Gemini Transaction ??

[MoRtAlAn]

Hab in meinem PHP-Enticklungsumgebung Code-schnipsel entdeckt, unter anderem folgendes, es wird dort als GEMINI-Transaction bezeichnet:

// Turn off autocommit
$sql_array = array("SET AUTOCOMMIT=0");

// First SQL Command
array_push($sql_array,"?SQL-1?");

// Next SQL Command
array_push($sql_array,"?SQL-2?");

// Commit transaction
array_push($sql_array," COMMIT");

// Turn on autocommit
array_push($sql_array,"SET AUTOCOMMIT=1");

while (list($key,$value) = each($sql_array)) {
   $result = mysql_db_query($dname, $value, $conn);
   if (!$result) {
       echo "<h3>Error</h3><p><b>".mysql_error()."</b></p>";
       mysql_db_query($dname, "ROLLBACK", $conn);
       mysql_db_query($dname, "SET AUTOCOMMIT=1", $conn);
       echo mysql_error($conn). "<br>";
       echo "Transaction rolled back.<br>";
       exit;
   }
} 

Kann mir jemand sagen, wozu das gut ist ??

gruss

[Titus]

Ich kenn nur die Cap Gemini Transaction.

Im Ernst - vielleicht wirst du daraus schlau: http://www.nusphere.com/products/proadv.htm
NuSphere's distribution of the MySQL database is the powerful choice, and the benchmarks prove it. In recent benchmark studies, Gemini (a table type designed by NuSphere) ranked highest in transactions per second with simultaneous users. In addition to performance, NuSphere's Gemini delivers row-locking, transaction support, crash recovery, and much more. Why is this important? Performance is what your users and visitors demand. If your Internet environment is unable to handle multiple transactions in a timely manner, the result may be lost revenue.

[MoRtAlAn]

THX, der 2. wars dann, obwohl der 1. auch nicht weit ab vom Thema war

gruss