Skip to Main Content
Forums

SQL Developer

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!

Need to tune performance issue of a sql query

Yogendra SinghDec 28 2020

issue_query.txt (5.24 KB)Hi,
I have a sql query which is causing performance issue for a specific customer. I am using standard oracle tables only to fetch the data. Can anybody please help in tuning attached query or else let me know if this could be something related to data issues for a specific customer.
For example: When i am providing cust_account_id as 328627 in attached query, it is retrieving 9987 rows in approx 16 sec while for cust_account_id as 1462371, it is retriving 8853 rows in approx 160 sec.

(Note: I am using SQL Developer to run attached query.)

Comments

MoC

Can you increase the font size instead of scaling the Text?

-fx-font-size: 2.0em;

This would fix the issue, I think.

user8929955

The StackPane will center everything you put into it. Use a Group instead.

NikolayArtamonov

Yes, it will fix the issue, but I need proportional scaling of text relative to size of stack pane. By the way, size of stack pane isn't fixed and may change on some conditions. It's hard to do with font size, that's why I use scaleX/Y properties.

MoC
Answer

You could try wrapping the Text in a Group. I tested in Scene Builder and it seemed to work ok with different StackPane alignments:

<?xml version="1.0" encoding="UTF-8"?>




<?import java.lang.*?>


<?import java.util.*?>


<?import javafx.scene.*?>


<?import javafx.scene.layout.*?>


<?import javafx.scene.paint.*?>


<?import javafx.scene.text.*?>




<StackPane alignment="TOP_LEFT" prefHeight="230.0" prefWidth="335.0" style="" xmlns:fx="http://javafx.com/fxml/1" xmlns="http://javafx.com/javafx/2.2">


  <children>


    <Group id="Group">


      <children>


        <Text layoutX="-29.0" layoutY="-11.0" scaleX="2.0" scaleY="2.0" strokeType="OUTSIDE" strokeWidth="0.0" text="Text" />


      </children>


    </Group>


  </children>


</StackPane>
Marked as Answer by NikolayArtamonov · Sep 27 2020
shakir.gusaroff

Hi. Try the following:

text.setTextAlignment(TextAlignment.LEFT);


StackPane.setAlignment(Pos.CENTER);
NikolayArtamonov

Thank you very much, MoC! Wrapping text to group gracefully solved the problem! )

1 - 6

Post Details

Added on Dec 28 2020
#oracle, #plsql, #sql, #sql-developer, #sqldeveloper
6 comments
279 views
1 mention