SQL-Window: Resultgrid is realy slow in PLSQLDev 10.0.5

[tseck]

Good morning,

Running a query in SQL-Window with many columns leads to a significant execution time. This period is NOT processing time but seems to be the time to build and draw the grid.

Changing window-type to Test-Window or Command-Window results in a much faster execution.

BTW: In PLSQLDev 9 the SQL-Window is as fast as the Command-Window

-- Test query 100 columns, SQL-Window 2secs, Test-Window 0secs
SELECT
1 AS w001, 1 AS w002, 1 AS w003, 1 AS w004, 1 AS w005, 1 AS w006, 1 AS w007, 1 AS w008, 1 AS w009, 1 AS w010,
1 AS w001, 1 AS w002, 1 AS w003, 1 AS w004, 1 AS w005, 1 AS w006, 1 AS w007, 1 AS w008, 1 AS w009, 1 AS w010,
1 AS w001, 1 AS w002, 1 AS w003, 1 AS w004, 1 AS w005, 1 AS w006, 1 AS w007, 1 AS w008, 1 AS w009, 1 AS w010,
1 AS w001, 1 AS w002, 1 AS w003, 1 AS w004, 1 AS w005, 1 AS w006, 1 AS w007, 1 AS w008, 1 AS w009, 1 AS w010,
1 AS w001, 1 AS w002, 1 AS w003, 1 AS w004, 1 AS w005, 1 AS w006, 1 AS w007, 1 AS w008, 1 AS w009, 1 AS w010,
1 AS w001, 1 AS w002, 1 AS w003, 1 AS w004, 1 AS w005, 1 AS w006, 1 AS w007, 1 AS w008, 1 AS w009, 1 AS w010,
1 AS w001, 1 AS w002, 1 AS w003, 1 AS w004, 1 AS w005, 1 AS w006, 1 AS w007, 1 AS w008, 1 AS w009, 1 AS w010,
1 AS w001, 1 AS w002, 1 AS w003, 1 AS w004, 1 AS w005, 1 AS w006, 1 AS w007, 1 AS w008, 1 AS w009, 1 AS w010,
1 AS w001, 1 AS w002, 1 AS w003, 1 AS w004, 1 AS w005, 1 AS w006, 1 AS w007, 1 AS w008, 1 AS w009, 1 AS w010,
1 AS w001, 1 AS w002, 1 AS w003, 1 AS w004, 1 AS w005, 1 AS w006, 1 AS w007, 1 AS w008, 1 AS w009, 1 AS w010,
1 AS w001, 1 AS w002, 1 AS w003, 1 AS w004, 1 AS w005, 1 AS w006, 1 AS w007, 1 AS w008, 1 AS w009, 1 AS w010,
1 AS w001, 1 AS w002, 1 AS w003, 1 AS w004, 1 AS w005, 1 AS w006, 1 AS w007, 1 AS w008, 1 AS w009, 1 AS w010,
1 AS w001, 1 AS w002, 1 AS w003, 1 AS w004, 1 AS w005, 1 AS w006, 1 AS w007, 1 AS w008, 1 AS w009, 1 AS w010,
1 AS w001, 1 AS w002, 1 AS w003, 1 AS w004, 1 AS w005, 1 AS w006, 1 AS w007, 1 AS w008, 1 AS w009, 1 AS w010,
1 AS w001, 1 AS w002, 1 AS w003, 1 AS w004, 1 AS w005, 1 AS w006, 1 AS w007, 1 AS w008, 1 AS w009, 1 AS w010,
1 AS w001, 1 AS w002, 1 AS w003, 1 AS w004, 1 AS w005, 1 AS w006, 1 AS w007, 1 AS w008, 1 AS w009, 1 AS w010,
1 AS w001, 1 AS w002, 1 AS w003, 1 AS w004, 1 AS w005, 1 AS w006, 1 AS w007, 1 AS w008, 1 AS w009, 1 AS w010,
1 AS w001, 1 AS w002, 1 AS w003, 1 AS w004, 1 AS w005, 1 AS w006, 1 AS w007, 1 AS w008, 1 AS w009, 1 AS w010
FROM dual WHERE 1=0

 

[Marco Kalter]

I do indeed see a 0.2 second difference for this query between the SQL Window and Test Window. We'll check it out.

 

[IvanZ]

Marko, how you get this little difference?

I got
1.578 sec in SQL window with max visual styles.
0.890 sec in SQL window with no visual styles.
0.078 sec in Command window.

It's a factor of ten.

 

[tseck]

Marco,

did a test with the above query modified to 200 columns.

plsqldev 1005: 7s (old xp desktop)
plsqldev 1005: 2s (win7 buisiness notebook)
plsqldev 902: 0.05s (same notebook)

 

[Marco Kalter]

Maybe my PC is a lot faster, so even if the absolute difference is smaller the relative difference does indicate that there is some overhead that might be reduced. We'll check it out.

 

[IvanZ]

I have core i7-2600, 24 Gb ram, Quadro 2000 at my workstation.
It showed not much difference in perfomance with Xeon server via RDP.

Please share, what OS do you use?

 

[Marco Kalter]

Windows 7 64 Bit, Core i7-2600, 8GB RAM.

But as stated before, we do see some time differences, so there may be some overhead we can reduce. If we can reduce it by 0.2 seconds for me, it may be reduced by 2 seconds for you.

 

[IvanZ]

PLD 11b1 has impoved in this regard.