duanruinong0619 2010-07-08 12:11
浏览 196
已采纳

PHP和Oracle OCI之间的等待时间很长

I installed XAMPP on Windows server. There are 2 application on my server:

First Application: PHP and MySQL application. This application runs quickly without and waiting time between links/pages.

Second Appilcation: PHP and Oracle application. I use “Oracle Instant Client (OCI) for Windows (32 bit)” to connect Oracle Server (on another machine). I have 8 tables with max 1000 row-data on each table. My queries are very simple. Everyting is working correctly when querying my Oracle database.

But, sometimes I’m waiting more than 20 seconds between pages/links. The is too much time to recieve page. This mostly occurs when entering the site for the first time. Additionaly, it occurs when trying to click on another page or link in application, after waiting 5-10 minutes on a page.

How can I reduce or terminate this delay when connecting Oracle database using OCI?

  • 写回答

1条回答 默认 最新

  • duanjian4331 2010-07-08 12:26
    关注

    How are you connecting? If you are using oci_connect, then that's probably a large part of the problem - switch to oci_pconnect.

    Failing that, do make sure that DNS A and PTR records are available for both ends (or make sure you're only using ip addresses rather than names to connect).

    C.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥85 maple软件,solve求反函数,出现rootof怎么办?
  • ¥15 求chat4.0解答一道线性规划题,用lingo编程运行,第一问要求写出数学模型和lingo语言编程模型,第二问第三问解答就行,我的ddl要到了谁来求了
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上