|
Re: Jubula on Oracle DB works slow. [message #1005109 is a reply to message #1004684] |
Thu, 24 January 2013 13:45 |
|
Well, this looks really strange. Normally the Oracle storage is way faster than H2 for large projects.
Possible (but not likely) causes:
* The DB instance is not configured for large data. We have had really bad performance before we increased the working area of the Oracle instance.
* You have a bad network connection to the DB server.
* There is a lot of other stuff going on in the DB instance.
* You have an outdated version of Jubula.
Throwing hardware at this problem is not likely to help since it is not typical behaviour for Jubula.
If you are allowed to share the project we might check it out during our performance improvement cycle.
Achim
|
|
|
|
Re: Jubula on Oracle DB works slow. [message #1006240 is a reply to message #1006047] |
Wed, 30 January 2013 14:48 |
|
After doing some checks we ran into a similar looking problem (which might be the same). Can you check if the generated indexes (PI_NODE_GUID would be fine) are actually populated. We found that for an (as of now) unknown reason the generated indexes might not be maintained by the db. Rebuilding them manually fixes the performance problems.
We'll keep you posted.
Achim
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.04480 seconds