Skip to content
← Customer Feedback for Devart

Settings and activity

2 results found

  1. set Fetch Size for Oracle Connection

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  dbForge Studio for Oracle  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Anonymous commented  · 

    This is as far as i understand:

    When you make a connection to Oracle, the fetchsize determines the amount of data that is transmitted in each round trip from the server to the client.

    Meaning, if you have a 3MB dataset and the fetchsize is 500kb, there will be 6 separate transactions to send the data (6 x 500kb = 3000kb = 3MB).

    There are also annoying separate fetch parameters for LOBs but i wasnt even bothering you about that.

    The idea was, basically, to try to speed things up.

    Often, when we run a query at sqlplus, we get the result back in .1ms, when we run it on dbforge, we get the result back in 7seconds. Thats a 70,000x difference and I wanted to see if we could narrow that gap somewhat.

    Anonymous shared this idea  · 

  2. Group database connections in Database Explorer

    110 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    4 comments  ·  dbForge Studio for Oracle  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    Anonymous supported this idea  ·