note 112387 added to ref.pdo-oci

Is PHP-to-Oracle much slower than Php-to-MySql ? I have battled my way through a conversion of Php4/MySql to Php5/Oracle (stumbling over Clobs and php5-variable-initialization). Everything works, but... Querys that took 8 seconds in MySql, now take 3 mintues with Oracle. Yes, I have indexes on the Oracle tables. Are Oracle connections that much more expensive than MySql? I did use oci_pconnect. ---- Server IP: 69.147.83.199 Probable Submitter: 204.2.163.2 ---- Manual Page -- http://php.net/manual/en/ref.pdo-oci.php Edit -- https://master.php.net/note/edit/112387 Del: integrated -- https://master.php.net/note/delete/112387/integrated Del: useless -- https://master.php.net/note/delete/112387/useless Del: bad code -- https://master.php.net/note/delete/112387/bad+code Del: spam -- https://master.php.net/note/delete/112387/spam Del: non-english -- https://master.php.net/note/delete/112387/non-english Del: in docs -- https://master.php.net/note/delete/112387/in+docs Del: other reasons-- https://master.php.net/note/delete/112387 Reject -- https://master.php.net/note/reject/112387 Search -- https://master.php.net/manage/user-notes.php