...
One of the biggest administrators 's concerns is how the Jira GUI is impacted by the app as this might confuse many users with new menus, etc. The impact of the app is minimal so the users should not be aware of anything new has been installed. Only very few and specific changes can be perceived by some users:
...
Since the 9.6.0 version, the action to open the SQL+JQL console is automatically hidden for non-trusted users.
Check installation
Run a simple benchmark by running this query:
Code Block | ||||
---|---|---|---|---|
| ||||
WITH RECURSIVE T(N) AS (
SELECT 1
UNION ALL
SELECT N+1 FROM T WHERE N<50000
)
SELECT count(*) FROM T; |
The query above creates 50K records in H2 and counts them. This is the average result from our development environment:
COUNT(*) |
---|
50000 |
(1 row, 20 ms)
It might help you to see how fast SQL+JQL will perform on your Jira.
Run some built-in examples from the built-in console to learn about SQL+JQL queries.
Troubleshooting
If you run into some problem, then please read theĀ Troubleshooting section to verify that the core features work as expected.
...