Skip to Main Content

SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Performance Issues in Query Result Pane

Dhruva MambapoorFeb 7 2024 — edited Feb 7 2024

Hi,

OS: Windows Build 10.0.19044

VS Code Version: 1.86.0.0

Oracle SQL Developer Extension for VSCode Version: 23.4.0

I am running a query that fetches data from an Oracle Database. (version obscured for security reasons).

The query is simple.

SET TIMING ON;
SELECT
*
FROM EXAMPLE_TBL
;

...

702 rows selected

When the query is run using SQLcl it takes 1.3 seconds.

When the query is run using Ctrl-Enter it fetches 100 rows in 25 seconds. Then, when scrolling down, it fetches another 100 rows, but this fetch takes drastically longer: 141 seconds. Any sorting takes equally as long, and resets the fetched rows back to 100. With 300 rows or more, scrolling slows or the query result panel freezes.

When the query is run using Oracle Developer Tools for VS Code Extension, it takes 2 seconds.

Other Extensions:

Better Comments - Aaron Bond

PowerShell - Microsoft

Vim - vscodevim

Is there anything I am doing wrong here? Are there any known performance issues?

@thatjeffsmith-oracle

It could be related to the following issues:
Slow query, possibly caused by high overhead in the Java back-end - Oracle Forums

This post has been answered by Dhruva Mambapoor on Feb 7 2024
Jump to Answer
Comments
Post Details
Added on Feb 7 2024
13 comments
518 views