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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
