Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Very Slow Oracle Connection Speed

Hello,   I'm trying to connect to an on-primise Oracle database. I followed this instrucution and installed ODAC and instant client.    This is the connection speed if I use sqldeveloper and each...
Need Help
arify's avatar
arify
Microsoft Employee
9 years ago

Hi Matthew,

 

When connecting the Oracle Database, in the prompt (where you enter your server name etc.) Is the checkbox "Include relationship columns" checked? If it is, can you check the performance without that checked?

 

If you want it to be faster with that option checked, a significant Oracle performance improvement is in our near-future plans :)

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

     Hello Arify,

     

    Sorry for replying to you late. I tried your method to uncheck the box. But the speed didn't improve that much... 

     

    I guess that's mainly my connection speed issue. Maybe I should wait for the new version release. I don't think I missed any key Orcale add-in to install, right?

     

    Thank you,

     

    Matthew

    • arify's avatar
      arify
      Microsoft Employee
      9 years ago

      If unchecking that checkbox didn't make it faster, then it's probably your connection speed.. Can you try some other tools to see if they're faster? (Make sure the results aren't cached, otherwise it would appear fast :) )

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago
    Thank you for the information and the insider news! I will double check that checkbox and let you know later today! Thank you, Matthew