×

Loading...
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

@Florida

Dear Duck, let me try to give you some hints

jabber(jabber)
I am so surprised.

I suggest you create a connection pool for your Database connections. This can be implemented using a JavaBean, or using a servlet. Be sure not write JDBC code directly in JSP file. Here is a good reference book
---Java Servlets by Karl Moss. You can downlod his code from www.servletguru.com. ou may also get working examples from other resources. The 5 minutes response time might be caused by the JSP compiling time. Have you tried the second time? If you hit the second time..., it might be shorter. Anyway, you should be confident in reducing this time
(#53574@0)
Last Updated: 2001-4-25
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

  • 工作学习 / IT技术讨论 / Jabber, Please help. About Jdbc. -blackswan(uglyduck); 2001-4-25 {287} (#53541@0)
    when I execute the store procedure from sybase client with sybase own interface function, the speed is very good(<1s). but the programmer execute it from jsp, the speed is very slow, sometimes more than 5 minutes.
    Could you give me an idea the way I can test out where the problem is?
    • The problem is the stupid JDBC! hehe... xDBC is doom to be slower. -pasu(InTheSky); 2001-4-25 (#53545@0)
      • but in the past it is not so slow. can I fix it? I used ODBC before never slow like that. -blackswan(uglyduck); 2001-4-25 (#53553@0)
    • Dear Duck, let me try to give you some hints -jabber(jabber); 2001-4-25 {593} (#53574@0)
      I am so surprised.

      I suggest you create a connection pool for your Database connections. This can be implemented using a JavaBean, or using a servlet. Be sure not write JDBC code directly in JSP file. Here is a good reference book
      ---Java Servlets by Karl Moss. You can downlod his code from www.servletguru.com. ou may also get working examples from other resources. The 5 minutes response time might be caused by the JSP compiling time. Have you tried the second time? If you hit the second time..., it might be shorter. Anyway, you should be confident in reducing this time
      • I tried it several times, the result is still same. I don't have idea on JAVA, I am a DBA, my co-worker said it was database problem, I think it is jdbc problem. I don't know who should solve that, it is beyond my knowledge -blackswan(uglyduck); 2001-4-25 (#53587@0)
        • Ask your Java programmer to write a Java utility program which uses the same JDBC driver and code. If this utility program access your database in a normal response then your part is fine. -guest:; 2001-4-25 (#53686@0)
          • Thanks -blackswan(uglyduck); 2001-4-26 (#54068@0)
            • 哈哈，我劳工水平可以吧。现在对大卡更有信心了。 -firefox99(firefox99); 2001-4-26 (#54071@0)
      • Check the web site of your database vendors and pick up a right JDBC driver. Before things are pinned down. don't admit it is a database problem. -jabber(jabber); 2001-4-26 (#54033@0)
    • It sounds jdbc driver problem, you may try different vendor's. -guest:; 2001-4-25 (#53684@0)
      • thanks -blackswan(uglyduck); 2001-4-25 (#53756@0)

More Topics

  • 看大家讨论日语，俺也正在认真学习。其实语言问题应该是很快也很容易就解决的，可能比自动驾驶来的还快。TREK里面，全宇宙的人都在大脑里安装了UNIVERSAL TRANSLATOR，外星人之间相互交流无障碍。废话少说，看视频。。。加上个MIC和耳机，不同国家的人就可以无障碍交流。
  • 肉脸真有搞 IT 的？Linux 把俄国中国伊朗踢出去了好像肉脸 IT 没啥感觉似的
  • 请问web developer和software developer技术上有什么区别？
  • Elon Musk 带着川普总统奔向火星了。
  • 扔硬币的实验研究
    • 枫下论坛主坛 /  工作学习 /  IT技术讨论