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

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.1
Status: Open
>Resolution: Later
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 
<mjaszczyk-/[email protected]>: 
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:40

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


-------------------------------------------------------
This SF.Net email sponsored by Black Hat Briefings & Training.
Attend Black Hat Briefings & Training, Las Vegas July 24-29 - 
digital self defense, top technical experts, no vendor pitches, 
unmatched networking opportunities. Visit www.blackhat.com