Sql editor improvement for batch execution support
- Dominant language
- Java
- Stars
- 3.1k
- Forks
- 935
- Avg merge
- 2d 3h
- Merged PRs (30d)
- 17
Description
### Description
Sometimes I using sql editor to fill new table. My sql-scripts looks like that:

If the script contains a huge number of lines, its execution is a very slow action. To speed up this action would be good use
`java.sql.Statement` method `executeBatch`.
### Use case/motivation
In a UI, this could be a toggle button, like [ToggleKeepOldResultTabsAction](https://github.com/apache/netbeans/blob/master/ide/db.sql.editor/src/org/netbeans/modules/db/sql/editor/ui/actions/ToggleKeepOldResultTabsAction.java):

### Related issues
_No response_
### Are you willing to submit a pull request?
Yes
### Code of Conduct
Yes
Contributor guide
Research direction
Start by reading the SQL editor execution path and the referenced ToggleKeepOldResultTabsAction.java. Compare the current script execution with java.sql.Statement.executeBatch and determine how a UI toggle should select batch execution. Done means the SQL editor offers the requested toggle and executes applicable scripts in batches without losing existing behavior.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- database, devtools
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100