[ https://issues.apache.org/jira/browse/DERBY-3716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12618781#action_12618781
]
Kathey Marsden commented on DERBY-3716:
---------------------------------------
To compress the tables, run:
call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP', '<tableName>', 1);
on all the tables in your database. See:
http://db.apache.org/derby/docs/10.4/ref/rrefaltertablecompress.html
> Impractically slow query
> ------------------------
>
> Key: DERBY-3716
> URL: https://issues.apache.org/jira/browse/DERBY-3716
> Project: Derby
> Issue Type: Bug
> Components: Performance, SQL
> 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.
|