# Difference in performance UI/jdbc

**URL:** https://community.dremio.com/t/difference-in-performance-ui-jdbc/6293
**Category:** Uncategorized
**Created:** [September 18, 2020, 9:08am UTC](https://community.dremio.com/t/difference-in-performance-ui-jdbc/6293 "2020-09-18T09:08:02Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![LucGth](https://avatars.discourse-cdn.com/v4/letter/l/858c86/32.png) [@LucGth](https://community.dremio.com/u/LucGth)
#### Post date: [September 18, 2020, 9:08am UTC](https://community.dremio.com/t/difference-in-performance-ui-jdbc/6293/1 "2020-09-18T09:08:02Z")

</div>

Hi,  
i’m working on a Dremio cluster v4.1.3 and i’ve noticed a strange behavior.  
If i run a query via jdbc, the time to complete it is much more larger than the time to finish the same query via UI. The payload of the query is the same, so i don’t think that the difference is caused by the UI authomatic truncation. Both the queries return the same Output Records (400k)  
These are the query profiles:  
[JDBC.zip](https://community.dremio.com/uploads/short-url/7CkBNiObELmYAfaDHKbMGDGQyWS.zip) (30,7 KB) [UI.zip](https://community.dremio.com/uploads/short-url/eUsu7JtJSI9vNWY08HmU2Ykzj58.zip) (32,9 KB)

thanks

---

<div class="post-metadata">

### Author: ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [September 24, 2020, 7:52am UTC](https://community.dremio.com/t/difference-in-performance-ui-jdbc/6293/2 "2020-09-24T07:52:13Z")

</div>

@LucGth

The reason is, although Dremio completed processing the records, the JDBC client is unable to consume at the same rate, if you see the first screen shot “phase-0-blocked-downstream.PNG” you will see that Dremio is all blocked on downstream on Phase 0 and downstream for Phase 0 is the JDBC client

 ![phase-0-blocked-downstream](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/9/9c3296d8cad9bc3f2435b13fc175fed3cfab4189.png)

If you see the second screen shot “screen.PNG”, all the time was spent on transferring the 231 MB over the wire.

 ![screen](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/3/36bfc1f10eec8877f9c87c703a80c00fd07f9062.png)

The actual query execution took only 1 second

Hope this helps

Thanks  
Bali