Slow Response Time

[rsanto06]

Hi,

Currently the response time that I got from NodeJS is between 3 to 5 seconds slower than the same query ran in the Databricks UI, e.g. in Databricks I have 0.5s, and in other side with NodeJS connector I got 4.5s.

There is anything that I can do to improve this?

I followed the documentation avaiable here: https://docs.databricks.com/dev-tools/nodejs-sql-driver.html

Thank you

[rsanto06]

@kravets-levko Do you have some time to check this? Thank you!

[kravets-levko]

@rsanto06

• which Nodejs connector version you use? Have you tried to upgrade to latest?
• do you run your queries against SQL Warehouse or Compute cluster? Which DBR version it uses?
• do you use AWS or Azure workspace?
• how large your query result is?
• is your warehouse/cluster already running when you execute your query? Keep in mind that DBSQL UI starts warehouse when you open the page, so most likely it's already up when you execute your query.
• does Nodejs conector execute the same query faster when you run it once more?
• if possible - please you try other conectors (Python or Go) and check if you experience similar latency or not