[openjms-developer] [ openjms-Bugs-872947 ] Index exiryTime, destinationId to avoid full table scans

SourceForge.net

2004-01-08 13:04:34 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
Group: v0.7.6-rc3
Status: Open
Resolution: None
Priority: 5
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.

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

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