×

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

Dear Duck, let me try to give you some hints

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
Report

Replies, comments and Discussions:

  • 工作学习 / IT技术讨论 / Jabber, Please help. About Jdbc.
    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.
      • but in the past it is not so slow. can I fix it? I used ODBC before never slow like that.
    • Dear Duck, let me try to give you some hints
      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
        • 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.
          • Thanks
            • 哈哈,我劳工水平可以吧。现在对大卡更有信心了。
      • 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.
    • It sounds jdbc driver problem, you may try different vendor's.
      • thanks