Re: JDBC Problem
- From: "joeNOSPAM@xxxxxxx" <joe.weinstein@xxxxxxxxx>
- Date: Wed, 07 Nov 2007 16:17:17 -0000
On Nov 5, 11:45 pm, xhy_China <xuhaiyan...@xxxxxxxxx> wrote:
Hi All,
I hava a problem about speed of database enquiry.
Problem:
It's a B/S application. Now I hava a database enquiry.
The statement stmt.executeQuery(sSQL) used long time(about 30s). The
return result have about 500 rows. If I copy the SQL to database
utilities to run it, itruns very fast(about 1-2s), why?? In another
function it also use stmt.executeQuery(sSQL)(returns about 500 rows),
it runs fast, so I dont think the reason is network between client,
database, server.
Could any one tell me why?? And how to change this
situation??
Thx for you suggestion!
Are you using a PreparedStatement? What JDBC driver and DBMS are you
using?
Joe Weinstein at BEA Systems
.
- References:
- JDBC Problem
- From: xhy_China
- JDBC Problem
- Prev by Date: Re: Problem with IN parameters to an Oracle stored procedure
- Next by Date: SQL Server - Very long query time with OpenJPA and Hibernate
- Previous by thread: JDBC Problem
- Next by thread: Problem with IN parameters to an Oracle stored procedure
- Index(es):
Relevant Pages
|
|
