RE: OCIExecute very slow when Updating rows

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



i think it's a usual transactionnal problem
i dont know what is your SQL update , but mostly the problem is there


-----Message d'origine-----
De : Krueger, Philipp [mailto:Philipp.Krueger@FORBATEC.com]
Envoyé : mardi 8 juillet 2003 09:13
À : 'php-db@lists.php.net'
Objet :  OCIExecute very slow when Updating rows


hi there!

sorry for bothering but i can't help myself anymore. i've written a small
hardware-database for my company with a webinterfaced based upon php. now:
everything works just fine - selects, inserts - everything works except for
the damn updates! 

### CODE ###

	$stmt = OCIParse($con,$query);
	if(!$stmt){$error=$con? OCIError($con):OCIError();echo "Error:
$error[code] $error[message]<br>";}
	else{
		OCIExecute($stmt,OCI_COMMIT_ON_SUCCESS);
		$error = OCIError($stmt);
		if ($error['code']){print "Fehler:
[".$error['message']."]";}}
	OCIFreeStatement($stmt);
	OCILogoff($con);

# ENDCODE #

i'm 100% sure everything is correct since sometimes the update DOES work - i
think it doesn't work anymore when there is the slightest activity on the
oracle-server (it's an  double cpu PowerPC RS64-IV running AIX Version 4.3
and Oracle 8.1.7.2) the server is BORED all the time but still the script is
not working... the script just times out 99 times and then for once it works
again.
the command which causes this delay is
"OCIExecute($stmt,OCI_COMMIT_ON_SUCCESS);". i tried to change the code to

### CODE ###

		OCIExecute($stmt,OCI_DEFAULT);
		OCICommit($con);

# ENDCODE #

but it still wouldn't work - when i comment OCIExecute out the script works
again - which is out of question of course since i need the damn script to
execute.
when i take the query and paste it in sqlplus to execute it manually
everything goes as planned. i'm beginning to get desperate here... any ideas
why it won't work?

hope anybody can help

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux