Bug 779048 (SOA-1457) - Update jbossesb-service.xml ExistsSql to use a more efficient SQL statement
Summary: Update jbossesb-service.xml ExistsSql to use a more efficient SQL statement
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-1457
Product: JBoss Enterprise SOA Platform 4
Classification: JBoss
Component: Configuration
Version: 4.3 CP01
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: ---
: 4.3 CP02
Assignee: Default User
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2009-08-20 14:16 UTC by david.boeren
Modified: 2009-11-09 19:39 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2009-11-09 19:39:37 UTC
Type: Feature Request

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-1457 0 None None None Never

Description david.boeren 2009-08-20 14:16:59 UTC 
Affects: Release Notes
Date of First Response: 2009-11-09 07:26:31
Help Desk Ticket Reference: https://enterprise.redhat.com/issue-tracker/?module=issues&action=view&tid=332311&gid=1354
project_key: SOA

The ExistsSql statement is run on startup to check for the existence of the message table.  Currently it uses:  select * from message

This can take both a considerable amount of time and memory if the message table is large and there is no need for it.

I suggest replacing this with select count (*) from message to speed up the server start and avoid potential out of memory errors if the table is large enough.
Comment 1 Julian Coleman 2009-11-09 12:26:31 UTC 
This was fixed for 4.3.0 CP02 with:
  http://fisheye.jboss.org/changelog/JBossESB?cs=26923
which changed the ExistsSql statements in:
  jbossesb.esb/jbossesb-service.xml
  jbpm.esb/jbpm-service.xml
to use:
  select count(*)
instead of:
  select *
Comment 2 Julian Coleman 2009-11-09 12:28:04 UTC 
Affects: Added: [Release Notes]
Comment 3 Julian Coleman 2009-11-09 12:34:35 UTC 
Also changed was:
  jbossesb.sar/esb.juddi.xml
Comment 4 Len DiMaggio 2009-11-09 19:39:37 UTC 
Verified in the 4.3 CP02 GA bits.
Note You need to log in before you can comment on or make changes to this bug.