Skip to Main Content

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!

[40 EA3]: MySQL connections not working any more

pschneider1968Nov 5 2013 — edited Nov 6 2013

Hi,

I have found a severe issue with 4.0 EA3: While in EA2, I could connect to a local MySQL database just fine and browse the schemas and tables, this does not work any longer in EA3.

Whereas in EA2, I saw schemas nodes depicted with a small "person" symbol under the connection node in the connections navigator, I now see folder symbols instead in EA3. Below these, they expand to "LOCAL TEMPORARY", "PROCEDURE", "TABLE", "VIEW" and I see no objects below them. In EA2, schema symbols expanded to "Tabellen", "Views", "Indizes", "Prozeduren", "Funktionen", "Trigger" and I could browse each category and could browse the tables just as one would expect. Locale is German with JDK 1.7.45 Win7 64bit, and I'm accessing a local MySQL 5.6.14 Community edition demo database with Connector J / 5.1.26.

Regards

Peter

Comments

user111989
Answer

Try to put and check if it reduces time. also check if it works for all the combination because we need target block for this to work

SET FRMLBOTTOMUP ON;

https://docs.oracle.com/cd/E57185_01/ESBTR/set_frmlbottomup.html

Marked as Answer by Zut Alors · Sep 27 2020
Jeo123

If you go to the logs when the calc is run, it'll tell you a bunch of useful things.  In particular, are you seeing notifications about calc mode being set to cell mode or something similar in there?

More importantly though, why not just agg the  geography dimension and then reference the total instead of doing a sum of the dimension on every entity?  Is there something in your app design that prevents that?

Zut Alors

@Jeo123

that's correct, aggregating a section of the dim would have helped, except there is some additional one-off calculation that need to occur

thanks,

cl

Zut Alors

that reduced the calc time by 80% - thank you!

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 4 2013
Added on Nov 5 2013
3 comments
309 views