[GitHub] [superset] Thrameos commented on issue #22086: How to connect Superset with Apahce Drill using JDBC URL

[GitBox <gi...@apache.org>]

Thrameos commented on issue #22086:
URL: https://github.com/apache/superset/issues/22086#issuecomment-1310893403

   I am not sure exactly what performance issues you are facing, but if you can set up to use JPype dbapi2 rather than JayDeBeApi you may get faster performance.  The JayDeBeAPI interface is a common bridge for Jython and Python to use, while JPype dbapi2 which is part of the JPype project is strictly CPython oriented, but at the same time it is 2 to 3 times faster.   If you need even faster access you may want to consider using column wise pulls rather than row wise using Apache Arrow.   
   
   I would recommend looking at this blog post.
   
   https://uwekorn.com/2020/12/30/fast-jdbc-revisited.html
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org