This topic has been archived. It cannot be replied.
-
工作学习 / 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?
-blackswan(uglyduck);
2001-4-25
{287}
(#53541@0)
-
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 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)