Hello,
I recently benchmarked using bind variables for inserts versus sending
simple sql over to oracle 8.1.7. Surprisingly, sending simple sql was
nearly 6 times faster. My database is using cursor_sharing=force.
Can anyone else verify this?
>>>>>>> Not using bind variables (MySQL and Oracle), using ADOdb library:
$DB->BeginTrans();
for ($i=0; $i < $NUMRECS; $i++) {
$DB->Execute(
"insert into test5000 (name,price,stock) values ('a name
$i',$i,$i)");
}
$DB->CommitTrans();
>>>>>>>>>> Using bind variables:
$DB->BeginTrans();
$a = '';
$b = 0;
$c = 0;
$stmt = OCIParse($DB->_connectionID,
"insert into test5000 (name,price,stock) values (:a,:b,:c)");
OCIBindByName($stmt,":a",&$a,32);
OCIBindByName($stmt,":b",&$b,32);
OCIBindByName($stmt,":c",&$c,32);
for ($i=0; $i < $NUMRECS; $i++) {
$a = "a name $i";
$b = $i;
$c = $i;
$e = OCIExecute($stmt);
if (!$e) {
print $DB->ErrorMsg();
break;
}
}
$DB->CommitTrans();
---
For more details, see:
http://php.weblogs.com/oracle_mysql_performance
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
