SourceForge.net
2004-07-03 13:40:44 UTC
Bugs item #872947, was opened at 2004-01-08 20:41
Message generated for change (Comment added) made by tanderson
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=872947&group_id=54559
Category: persistence
Submitted By: Tim Anderson (tanderson)
Assigned to: Tim Anderson (tanderson)
Summary: Index exiryTime, destinationId to avoid full table scans
Initial Comment:
Extract from mail from Michael Jaszczyk
<***@pi...>:
http://sourceforge.net/mailarchive/forum.php?
thread_id=3694232&forum_id=11794
Attached patch for create_oracle.sql adds index on
expirytime and destinatioinid to avoid full tables scans.
Might be a good idea for other rdbms, too.
----------------------------------------------------------------------
Message:
Logged In: YES
user_id=557161
The change to create_oracle.sql has been applied as per
request 964261.
However, similar changes should also be applied to each of
the other databases, so leaving this request open.
----------------------------------------------------------------------
Comment By: Michael Jaszczyk (mjaszczyk)
Date: 2004-06-01 23:15
Message:
Logged In: YES
user_id=940611
added a new patch for oracle, which also changes the table
definitions to use primary keys with the reuqest ID:964261
----------------------------------------------------------------------
Comment By: Tim Anderson (tanderson)
Date: 2004-01-09 00:04
Message:
Logged In: YES
user_id=557161
Not sure I want to apply this patch before the final 0.7.6
release as the master database schema
(src/main/org/exolab/jms/tools/db/schema.xml) should be
updated first
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=872947&group_id=54559
Message generated for change (Comment added) made by tanderson
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=872947&group_id=54559
Category: persistence
Group: v0.7.6.1
Status: OpenResolution: Later
Priority: 5Submitted By: Tim Anderson (tanderson)
Assigned to: Tim Anderson (tanderson)
Summary: Index exiryTime, destinationId to avoid full table scans
Initial Comment:
Extract from mail from Michael Jaszczyk
<***@pi...>:
http://sourceforge.net/mailarchive/forum.php?
thread_id=3694232&forum_id=11794
Attached patch for create_oracle.sql adds index on
expirytime and destinatioinid to avoid full tables scans.
Might be a good idea for other rdbms, too.
----------------------------------------------------------------------
Comment By: Tim Anderson (tanderson)
Date: 2004-07-03 23:40Message:
Logged In: YES
user_id=557161
The change to create_oracle.sql has been applied as per
request 964261.
However, similar changes should also be applied to each of
the other databases, so leaving this request open.
----------------------------------------------------------------------
Comment By: Michael Jaszczyk (mjaszczyk)
Date: 2004-06-01 23:15
Message:
Logged In: YES
user_id=940611
added a new patch for oracle, which also changes the table
definitions to use primary keys with the reuqest ID:964261
----------------------------------------------------------------------
Comment By: Tim Anderson (tanderson)
Date: 2004-01-09 00:04
Message:
Logged In: YES
user_id=557161
Not sure I want to apply this patch before the final 0.7.6
release as the master database schema
(src/main/org/exolab/jms/tools/db/schema.xml) should be
updated first
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=872947&group_id=54559