Performance issues with PHP/Oracle/PDO

[Anthony Smith]

How can I make these inserts faster?
$insert = "INSERT into AFF_KIAC_ACCT_A LIGNMENT " .
"(KIAC_ACCT_NBR , REGION_CD, ORIGIN_LOC_CD,T ERRITORY, FISCAL_HALF,
FISCAL_YEAR, MAINT_USER_ID)" .
" values
(:acct, :region, :origin, :territory, :half, :year, :userid)";

$stmt = $con->prepare($inser t);
for($idx=0; $idx<count($lin es); $idx++) {
$items = explode($token, trim($lines[$idx]));
$stmt->bindParam(":ac ct", $items[0]);
$stmt->bindParam(":re gion", $items[1]);
$stmt->bindParam(":or igin", $items[2]);
$stmt->bindParam(":te rritory", $items[3]);
$stmt->bindParam(":ha lf", $_SESSION["half"]);
$stmt->bindParam(":ye ar", $_SESSION["year"]);
$stmt->bindParam(":us erid", $_SESSION["employee_numbe r"]);
$stmt->execute();
}

[Jerry Stuckle]

Anthony Smith wrote:

How can I make these inserts faster?
$insert = "INSERT into AFF_KIAC_ACCT_A LIGNMENT " .
"(KIAC_ACCT_NBR , REGION_CD, ORIGIN_LOC_CD,T ERRITORY, FISCAL_HALF,
FISCAL_YEAR, MAINT_USER_ID)" .
" values
(:acct, :region, :origin, :territory, :half, :year, :userid)";

$stmt = $con->prepare($inser t);
for($idx=0; $idx<count($lin es); $idx++) {
$items = explode($token, trim($lines[$idx]));
$stmt->bindParam(":ac ct", $items[0]);
$stmt->bindParam(":re gion", $items[1]);
$stmt->bindParam(":or igin", $items[2]);
$stmt->bindParam(":te rritory", $items[3]);
$stmt->bindParam(":ha lf", $_SESSION["half"]);
$stmt->bindParam(":ye ar", $_SESSION["year"]);
$stmt->bindParam(":us erid", $_SESSION["employee_numbe r"]);
$stmt->execute();
}

How much faster do you need them? From the PHP end, you aren't going to
be able to gain a whole lot more performance.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[Anthony Smith]

On Nov 3, 2:09*pm, Anthony Smith <mrsmi...@hotma il.comwrote:

How can I make these inserts faster?

* * * * * * * * $insert = "INSERT into AFF_KIAC_ACCT_A LIGNMENT " .
* * * * * * * * * * * * * * * * "(KIAC_ACCT_NBR , REGION_CD, ORIGIN_LOC_CD,T ERRITORY, FISCAL_HALF,
FISCAL_YEAR, MAINT_USER_ID)" .
* * * * * * * * * * * * * * * * " values
(:acct, :region, :origin, :territory, :half, :year, :userid)";

* * * * * * * * $stmt = $con->prepare($inser t);
* * * * * * * * for($idx=0; $idx<count($lin es); $idx++){

* * * * * * * * * * * * $items = explode($token, trim($lines[$idx]));
* * * * * * * * * * * * $stmt->bindParam(":ac ct",$items[0]);
* * * * * * * * * * * * $stmt->bindParam(":re gion", $items[1]);
* * * * * * * * * * * * $stmt->bindParam(":or igin", $items[2]);
* * * * * * * * * * * * $stmt->bindParam(":te rritory", $items[3]);
* * * * * * * * * * * * $stmt->bindParam(":ha lf",$_SESSION["half"]);
* * * * * * * * * * * * $stmt->bindParam(":ye ar",$_SESSION["year"]);
* * * * * * * * * * * * $stmt->bindParam(":us erid", $_SESSION["employee_numbe r"]);
* * * * * * * * * * * * $stmt->execute();
* * * * }

My proxy is timing out. I am thinking there is one change that maybe
can be made to solved this issue.

[MacRules]

Is there a connection cache feature on Apache side or PHP/Oracle connect
call?

Anthony Smith wrote:

On Nov 3, 2:09 pm, Anthony Smith <mrsmi...@hotma il.comwrote:

>How can I make these inserts faster?

$insert = "INSERT into AFF_KIAC_ACCT_A LIGNMENT " .
"(KIAC_ACCT_NBR , REGION_CD, ORIGIN_LOC_CD,T ERRITORY, FISCAL_HALF,
FISCAL_YEAR, MAINT_USER_ID)" .
" values
(:acct, :region, :origin, :territory, :half, :year, :userid)";

$stmt = $con->prepare($inser t);
for($idx=0; $idx<count($lin es); $idx++) {

$items = explode($token, trim($lines[$idx]));
$stmt->bindParam(":ac ct", $items[0]);
$stmt->bindParam(":re gion", $items[1]);
$stmt->bindParam(":or igin", $items[2]);
$stmt->bindParam(":te rritory", $items[3]);
$stmt->bindParam(":ha lf", $_SESSION["half"]);
$stmt->bindParam(":ye ar", $_SESSION["year"]);
$stmt->bindParam(":us erid", $_SESSION["employee_numbe r"]);
$stmt->execute();
}

My proxy is timing out. I am thinking there is one change that maybe
can be made to solved this issue.

[Jerry Stuckle]

Anthony Smith wrote:

On Nov 3, 2:09 pm, Anthony Smith <mrsmi...@hotma il.comwrote:

>How can I make these inserts faster?

$insert = "INSERT into AFF_KIAC_ACCT_A LIGNMENT " .
"(KIAC_ACCT_NBR , REGION_CD, ORIGIN_LOC_CD,T ERRITORY, FISCAL_HALF,
FISCAL_YEAR, MAINT_USER_ID)" .
" values
(:acct, :region, :origin, :territory, :half, :year, :userid)";

$stmt = $con->prepare($inser t);
for($idx=0; $idx<count($lin es); $idx++) {

$items = explode($token, trim($lines[$idx]));
$stmt->bindParam(":ac ct", $items[0]);
$stmt->bindParam(":re gion", $items[1]);
$stmt->bindParam(":or igin", $items[2]);
$stmt->bindParam(":te rritory", $items[3]);
$stmt->bindParam(":ha lf", $_SESSION["half"]);
$stmt->bindParam(":ye ar", $_SESSION["year"]);
$stmt->bindParam(":us erid", $_SESSION["employee_numbe r"]);
$stmt->execute();
}

My proxy is timing out. I am thinking there is one change that maybe
can be made to solved this issue.

How many updates are you trying to do? And how long does it take for
the connection to time out?

My thoughts are that this is not where your problem lies.
--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[Jerry Stuckle]

MacRules wrote:

Anthony Smith wrote:

>On Nov 3, 2:09 pm, Anthony Smith <mrsmi...@hotma il.comwrote:

>>How can I make these inserts faster?

$insert = "INSERT into AFF_KIAC_ACCT_A LIGNMENT " .
"(KIAC_ACCT_NBR , REGION_CD,
ORIGIN_LOC_CD ,TERRITORY, FISCAL_HALF,
FISCAL_YEAR , MAINT_USER_ID)" .
" values
(:acct, :region, :origin, :territory, :half, :year, :userid)";

$stmt = $con->prepare($inser t);
for($idx=0; $idx<count($lin es); $idx++) {

$items = explode($token, trim($lines[$idx]));
$stmt->bindParam(":ac ct", $items[0]);
$stmt->bindParam(":re gion", $items[1]);
$stmt->bindParam(":or igin", $items[2]);
$stmt->bindParam(":te rritory", $items[3]);
$stmt->bindParam(":ha lf", $_SESSION["half"]);
$stmt->bindParam(":ye ar", $_SESSION["year"]);
$stmt->bindParam(":us erid",
$_SESSION["employee_numbe r"]);
$stmt->execute();
}

My proxy is timing out. I am thinking there is one change that maybe
can be made to solved this issue.

Is there a connection cache feature on Apache side or PHP/Oracle
connect call?

(Top posting fixed)

Which does absolutely nothing to solve this problem. He's only making
one connection, and making the connection won't take that much time.

P.S. Please don't top post. Thanks.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[C. (http://symcbean.blogspot.com/)]

On 3 Nov, 20:35, Anthony Smith <mrsmi...@hotma il.comwrote:

On Nov 3, 2:09 pm, Anthony Smith <mrsmi...@hotma il.comwrote:

How can I make these inserts faster?

<snip>

My proxy is timing out. I am thinking there is one change that maybe
can be made to solved this issue.

Don't use Oracle?

If you don't have a code profiler / debugger installed, try running a
test harness from the CLI to identify where its going slow:

function report($msg)
{
static $started;
if (!$started) $started=microt ime(true);
print $msg . " at time " . microtime(true) - $started . " s \n";
flush();
}

$base=microtime (true);
report('start') ;
$con=new PDO(....);
report('connect ed');
$insert = "INSERT into AFF_KIAC_ACCT_A LIGNMENT " .
"(KIAC_ACCT_NBR , REGION_CD,
ORIGIN_LOC_CD,T ERRITORY, FISCAL_HALF,
FISCAL_YEAR, MAINT_USER_ID)" .
" values
(:acct, :region, :origin, :territory, :half, :year, :userid)";

$stmt = $con->prepare($inser t);
report("prepare d");
for($idx=0; $idx<count($lin es); $idx++) {
report("line $idx started");
$items = explode($token, trim($lines[$idx]));
$stmt->bindParam(":ac ct", $items[0]);
$stmt->bindParam(":re gion", $items[1]);
$stmt->bindParam(":or igin", $items[2]);
$stmt->bindParam(":te rritory", $items[3]);
$stmt->bindParam(":ha lf", $_SESSION["half"]);
$stmt->bindParam(":ye ar", $_SESSION["year"]);
$stmt->bindParam(":us erid",
$_SESSION["employee_numbe r"]);
report("line $idx about to submit");
$stmt->execute();
report("execute d");
}
C.