10:40 a.m.
get schema reviewed by real dba
-------------------------------
Key: JBPM-2117
URL: https://jira.jboss.org/jira/browse/JBPM-2117
Project: JBoss jBPM
Issue Type: Task
Security Level: Public (Everyone can see)
Reporter: Tom Baeyens
Assignee: Tom Baeyens
Fix For: jBPM 4.0.0.CR1
gert leenders might know someone that might be willing to have a look at it.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:38 p.m.
New subject: [JBoss JIRA] Commented: (JBPM-2117) get schema reviewed by real dba
[
https://jira.jboss.org/jira/browse/JBPM-2117?page=com.atlassian.jira.plug...
]
Ronald van Kuijk commented on JBPM-2117:
----------------------------------------
Would be good to not only have him look at the schema, but also use e.g. a queryanalyzer
(like oracle statistics) in a running server (e.g. when the load test is run) to get even
better tuning
get schema reviewed by real dba
-------------------------------
Key: JBPM-2117
URL: https://jira.jboss.org/jira/browse/JBPM-2117
Project: JBoss jBPM
Issue Type: Task
Security Level: Public(Everyone can see)
Reporter: Tom Baeyens
Assignee: Tom Baeyens
Fix For: jBPM 4.0.0.CR1
gert leenders might know someone that might be willing to have a look at it.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:22 a.m.
New subject: [JBoss JIRA] Updated: (JBPM-2117) get schema reviewed by real dba
[
https://jira.jboss.org/jira/browse/JBPM-2117?page=com.atlassian.jira.plug...
]
Tom Baeyens updated JBPM-2117:
------------------------------
Priority: Optional (was: Major)
get schema reviewed by real dba
-------------------------------
Key: JBPM-2117
URL: https://jira.jboss.org/jira/browse/JBPM-2117
Project: JBoss jBPM
Issue Type: Task
Security Level: Public(Everyone can see)
Reporter: Tom Baeyens
Assignee: Tom Baeyens
Priority: Optional
Fix For: jBPM 4.0.0.CR1
gert leenders might know someone that might be willing to have a look at it.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:34 a.m.
New subject: [JBoss JIRA] Updated: (JBPM-2117) get schema reviewed by real dba
[
https://jira.jboss.org/jira/browse/JBPM-2117?page=com.atlassian.jira.plug...
]
Tom Baeyens updated JBPM-2117:
------------------------------
Attachment: jbpm.db.scripts.zip
get schema reviewed by real dba
-------------------------------
Key: JBPM-2117
URL: https://jira.jboss.org/jira/browse/JBPM-2117
Project: JBoss jBPM
Issue Type: Task
Security Level: Public(Everyone can see)
Reporter: Tom Baeyens
Assignee: Tom Baeyens
Priority: Optional
Fix For: jBPM 4.0.0.CR1
Attachments: jbpm.db.scripts.zip
gert leenders might know someone that might be willing to have a look at it.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:20 p.m.
New subject: [JBoss JIRA] Updated: (JBPM-2117) get schema reviewed by real dba
[
https://jira.jboss.org/jira/browse/JBPM-2117?page=com.atlassian.jira.plug...
]
Tom Baeyens updated JBPM-2117:
------------------------------
Fix Version/s: jBPM 4.0
(was: jBPM 4.0.CR1)
get schema reviewed by real dba
-------------------------------
Key: JBPM-2117
URL: https://jira.jboss.org/jira/browse/JBPM-2117
Project: JBoss jBPM
Issue Type: Task
Security Level: Public(Everyone can see)
Reporter: Tom Baeyens
Assignee: Tom Baeyens
Priority: Optional
Fix For: jBPM 4.0
Attachments: jbpm.db.scripts.zip
gert leenders might know someone that might be willing to have a look at it.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:17 p.m.
New subject: [JBoss JIRA] Assigned: (JBPM-2117) get schema reviewed by real dba
[
https://jira.jboss.org/jira/browse/JBPM-2117?page=com.atlassian.jira.plug...
]
Tom Baeyens reassigned JBPM-2117:
---------------------------------
Assignee: Joram Barrez (was: Tom Baeyens)
get schema reviewed by real dba
-------------------------------
Key: JBPM-2117
URL: https://jira.jboss.org/jira/browse/JBPM-2117
Project: JBoss jBPM
Issue Type: Task
Security Level: Public(Everyone can see)
Reporter: Tom Baeyens
Assignee: Joram Barrez
Priority: Optional
Fix For: jBPM 4.0
Attachments: jbpm.db.scripts.zip
gert leenders might know someone that might be willing to have a look at it.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:24 p.m.
New subject: [JBoss JIRA] Commented: (JBPM-2117) get schema reviewed by real dba
[
https://jira.jboss.org/jira/browse/JBPM-2117?page=com.atlassian.jira.plug...
]
Tom Baeyens commented on JBPM-2117:
-----------------------------------
comment van Gerd:
"
alleen het schema ben ik niet zo heel veel, ik kan wel al even de constraints bekijken om
te zien of die allemaal ok zijn.
Indien je een ERD beschikbaar hebt of een UML datamodel of iets dergelijks dan kan mij dat
ook helpen om een beter beeld te krijgen van de het DB schema.
Het wordt pas interessant als we kunnen kijken naar de SQL Select statements die naar de
db gestuurd worden.
Zeker de SQL statements die vaak worden uitgevoed zijn de moeite om even te onderzoeken,
daarna kunnen we deze dan desnoods optimaliseren door bijkomende indexen te creëren.
Ik weet niet of je hiervoor een aparte testsuite moet schrijven, misschien kunnen we in
een latere fase via SQL logging op hibernate een goed beeld krijgen van de statements die
worden doorgestuurd naar de db.
"
get schema reviewed by real dba
-------------------------------
Key: JBPM-2117
URL: https://jira.jboss.org/jira/browse/JBPM-2117
Project: JBoss jBPM
Issue Type: Task
Security Level: Public(Everyone can see)
Reporter: Tom Baeyens
Assignee: Joram Barrez
Priority: Optional
Fix For: jBPM 4.0
Attachments: jbpm.db.scripts.zip
gert leenders might know someone that might be willing to have a look at it.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:30 p.m.
New subject: [JBoss JIRA] Commented: (JBPM-2117) get schema reviewed by real dba
[
https://jira.jboss.org/jira/browse/JBPM-2117?page=com.atlassian.jira.plug...
]
Tom Baeyens commented on JBPM-2117:
-----------------------------------
joram will first try to create a set of tests that produce the most common transactions
and make the SQL easily extractable. the common transactions are probably the same as for
the load testing (see JBPM-2310). then jora will contact gerd and see if he can arrange
a meeting. that'll be easier to move this forward quickly.
get schema reviewed by real dba
-------------------------------
Key: JBPM-2117
URL: https://jira.jboss.org/jira/browse/JBPM-2117
Project: JBoss jBPM
Issue Type: Task
Security Level: Public(Everyone can see)
Reporter: Tom Baeyens
Assignee: Joram Barrez
Priority: Optional
Fix For: jBPM 4.0
Attachments: jbpm.db.scripts.zip
gert leenders might know someone that might be willing to have a look at it.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:47 p.m.
New subject: [JBoss JIRA] Work started: (JBPM-2117) get schema reviewed by real dba
[
https://jira.jboss.org/jira/browse/JBPM-2117?page=com.atlassian.jira.plug...
]
Work on JBPM-2117 started by Joram Barrez.
get schema reviewed by real dba
-------------------------------
Key: JBPM-2117
URL: https://jira.jboss.org/jira/browse/JBPM-2117
Project: JBoss jBPM
Issue Type: Task
Security Level: Public(Everyone can see)
Reporter: Tom Baeyens
Assignee: Joram Barrez
Priority: Optional
Fix For: jBPM 4.0
Attachments: jbpm.db.scripts.zip
gert leenders might know someone that might be willing to have a look at it.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:30 p.m.
New subject: [JBoss JIRA] Updated: (JBPM-2117) get schema reviewed by real dba
[
https://jira.jboss.org/jira/browse/JBPM-2117?page=com.atlassian.jira.plug...
]
Joram Barrez updated JBPM-2117:
-------------------------------
Fix Version/s: jBPM 4.1
(was: jBPM 4.0)
get schema reviewed by real dba
-------------------------------
Key: JBPM-2117
URL: https://jira.jboss.org/jira/browse/JBPM-2117
Project: JBoss jBPM
Issue Type: Task
Security Level: Public(Everyone can see)
Reporter: Tom Baeyens
Assignee: Joram Barrez
Priority: Optional
Fix For: jBPM 4.1
Attachments: jbpm.db.scripts.zip
gert leenders might know someone that might be willing to have a look at it.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:30 p.m.
New subject: [JBoss JIRA] Work stopped: (JBPM-2117) get schema reviewed by real dba
[
https://jira.jboss.org/jira/browse/JBPM-2117?page=com.atlassian.jira.plug...
]
Work on JBPM-2117 stopped by Joram Barrez.
get schema reviewed by real dba
-------------------------------
Key: JBPM-2117
URL: https://jira.jboss.org/jira/browse/JBPM-2117
Project: JBoss jBPM
Issue Type: Task
Security Level: Public(Everyone can see)
Reporter: Tom Baeyens
Assignee: Joram Barrez
Priority: Optional
Fix For: jBPM 4.1
Attachments: jbpm.db.scripts.zip
gert leenders might know someone that might be willing to have a look at it.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:32 p.m.
New subject: [JBoss JIRA] Commented: (JBPM-2117) get schema reviewed by real dba
[
https://jira.jboss.org/jira/browse/JBPM-2117?page=com.atlassian.jira.plug...
]
Joram Barrez commented on JBPM-2117:
------------------------------------
Deferred to 4.1. No DBA was found willing to take a look at the schema.
At this point in time, it would also not be wise to introduce db changes.
get schema reviewed by real dba
-------------------------------
Key: JBPM-2117
URL: https://jira.jboss.org/jira/browse/JBPM-2117
Project: JBoss jBPM
Issue Type: Task
Security Level: Public(Everyone can see)
Reporter: Tom Baeyens
Assignee: Joram Barrez
Priority: Optional
Fix For: jBPM 4.1
Attachments: jbpm.db.scripts.zip
gert leenders might know someone that might be willing to have a look at it.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:14 a.m.
New subject: [JBoss JIRA] Commented: (JBPM-2117) get schema reviewed by real dba
[
https://jira.jboss.org/jira/browse/JBPM-2117?page=com.atlassian.jira.plug...
]
Tom Baeyens commented on JBPM-2117:
-----------------------------------
Gert:
"
Ik ken zelf wel het één en ander van DB's en kan inderdaad anders wel op een DBA
beroep doen.
Maar om een de DB te kunnen optimaliseren is het vooral belangrijk om een beeld te krijgen
van de statements die worden uitgevoerd.
Dus lijkt het mij in de eerste plaats handig om via SQL Logging te kijken welke statements
het meeste worden uitgevoerd op de db.
Aan de hand daarvan kunnen we dan bekijken of we beter bepaalde indexen toevoegen.etc.
"
get schema reviewed by real dba
-------------------------------
Key: JBPM-2117
URL: https://jira.jboss.org/jira/browse/JBPM-2117
Project: JBoss jBPM
Issue Type: Task
Security Level: Public(Everyone can see)
Reporter: Tom Baeyens
Assignee: Joram Barrez
Priority: Optional
Fix For: jBPM 4.1
Attachments: jbpm.db.scripts.zip
gert leenders might know someone that might be willing to have a look at it.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:56 p.m.
New subject: [JBoss JIRA] Updated: (JBPM-2117) get schema reviewed by real dba
[
https://jira.jboss.org/jira/browse/JBPM-2117?page=com.atlassian.jira.plug...
]
Tom Baeyens updated JBPM-2117:
------------------------------
Fix Version/s: jBPM 4.x
(was: jBPM 4.1)
get schema reviewed by real dba
-------------------------------
Key: JBPM-2117
URL: https://jira.jboss.org/jira/browse/JBPM-2117
Project: JBoss jBPM
Issue Type: Task
Security Level: Public(Everyone can see)
Reporter: Tom Baeyens
Assignee: Joram Barrez
Priority: Optional
Fix For: jBPM 4.x
Attachments: jbpm.db.scripts.zip
gert leenders might know someone that might be willing to have a look at it.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:53 a.m.
New subject: [JBoss JIRA] Assigned: (JBPM-2117) get schema reviewed by real dba
[
https://jira.jboss.org/jira/browse/JBPM-2117?page=com.atlassian.jira.plug...
]
Joram Barrez reassigned JBPM-2117:
----------------------------------
Assignee: (was: Joram Barrez)
get schema reviewed by real dba
-------------------------------
Key: JBPM-2117
URL: https://jira.jboss.org/jira/browse/JBPM-2117
Project: jBPM
Issue Type: Task
Security Level: Public(Everyone can see)
Reporter: Tom Baeyens
Priority: Optional
Fix For: jBPM 4.x
Attachments: jbpm.db.scripts.zip
gert leenders might know someone that might be willing to have a look at it.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5286
days inactive
5577
days old
14 comments
3 participants
participants (3)
-
Joram Barrez (JIRA) -
Ronald van Kuijk (JIRA)
-
Tom Baeyens (JIRA)