db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: Query performance of joining table and a view
Date Mon, 31 Jul 2006 15:14:38 GMT
> The problem is the result from this query returns me after 25 minutes 
> later. Can anybody suggest anything about What the problem is?

It sounds like you're getting the results that you expect from your
query, but it's taking much longer than you expect.

If that's true, than the problem is that the database is doing more
work than you want it to, which you may be able to fix by adding indexes
or restating your query.

To start with, you're going to need to gather a lot more information.

Here are some good places to start:

http://db.apache.org/derby/docs/dev/tuning/ttundepth33391.html

http://wiki.apache.org/db-derby/PerformanceDiagnosisTips

thanks,

bryan


Mime
View raw message