[ openjms-Bugs-872947 ] Index exiryTime, destinationId to avoid full table scans
"SourceForge.net" <[email protected]>
| Newsgroups | gmane.comp.java.openjms.devel |
|---|---|
| Message-ID | <[email protected]> |
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 <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-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 is sponsored by: Perforce Software. Perforce is the Fast Software Configuration Management System offering advanced branching capabilities and atomic changes on 50+ platforms. Free Eval! http://www.perforce.com/perforce/loadprog.html