utPLSQL Performance Test Suite #1333
Replies: 4 comments
-
|
We could do similar setup for suite setup (parsing/reading cache tables) |
Beta Was this translation helpful? Give feedback.
-
|
There are few areas that could benefit from constant monitoring, I think quite important is to decide at what point it will run and on what volume. I believe this should be part of develop only volume wise not sure what we consider big but not too big. |
Beta Was this translation helpful? Give feedback.
-
|
The only concern on my side is the build time.
Even today I notice that it's quite annoying to have to wait 9-10 minutes for build to finish. |
Beta Was this translation helpful? Give feedback.
-
|
I see three main areas of performance testing:
All three scenarios could be covered with a schema containing significant number of packages and lines of code in spec/body. We could use a package generator. Here is an old script i used(attached). |
Beta Was this translation helpful? Give feedback.
Uh oh!
There was an error while loading. Please reload this page.
-
Motivation
With utPLSQL v3.1.4 - v3.1.6 some performance related issues were introduced. See #882 and #888. Fixing the issue required some collaboration with others, which worked very well. However, we should introduce a mechanism to avoid or at least try to avoid such problems in the future.
Feature Request
I suggest to write performance tests suites with the following main goal:
When running a reporter consumer in a dedicated process the overhead of a reporter (in most cases) should be reduced to something like an
INSERTin the producing main process. In such a setup a reporter should never be the main contributor to the overall end-to-end runtime.Technically I think the current development environment could be used for these performance tests. It should be good enough to identify relative performance issues between the current develop branch and the latest release. A dedicated shell script could do the job.
Beta Was this translation helpful? Give feedback.
All reactions