db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Evan Leonard (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-3716) Impractically slow query
Date Mon, 09 Jun 2008 20:48:45 GMT
Impractically slow query
------------------------

                 Key: DERBY-3716
                 URL: https://issues.apache.org/jira/browse/DERBY-3716
             Project: Derby
          Issue Type: Bug
          Components: Performance
    Affects Versions: 10.4.1.3
         Environment: tried on both win2k and  os x
java 1.6, hibernate
            Reporter: Evan Leonard


Here's the query I'm trying to run in hibernate query language(hql). I'll give a version in
sql afterward. It contains a number joins and a sum. When the tables are empty the query completes.
When there are more than ~20 rows in these tables the query (practially speaking) never completes.
 I've looked at the thread dumps while its running and they're in data.row something, and
don't appear to be dead-locked according to the JVM. Other databases execute this query without
a problem

---------hql---------------

select sum(bd.length)
from User u, WorkspaceBean w, ExchangeEntry ee, ExchangeBean e, MessageBase m, BinaryData
bd
where (u = :user) and
         ((u = w.creator and w = ee.workspace and e = ee.exchange and m = e.input and m.binData
= bd) or
          (u = w.creator and w = ee.workspace and e = ee.exchange and m = e.output and m.binData
= bd))

---------sql--------------

select sum(bd.length)
from User u, WorkspaceBean w, ExchangeEntry ee, ExchangeBean e, MessageBase m, BinaryData
bd
where (u.id = @userId) and
         ((u.id = w.creatorId and w.id = ee.workspaceId and e.id = ee.exchangeId and m.id
= e.inputId and m.binDataId = bd.id) or
          (u.id = w.creatorId and w.id = ee.workspaceId and e.id = ee.exchangeId and m.id
= e.outputId and m.binDataId = bd.id))

-------------------------

Thank you!
Evan

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message