cancel
Showing results for 
Search instead for 
Did you mean: 
Get Started Discussions
Start your journey with Databricks by joining discussions on getting started guides, tutorials, and introductory topics. Connect with beginners and experts alike to kickstart your Databricks experience.
cancel
Showing results for 
Search instead for 
Did you mean: 

Experiencing Performance Issues When Using Databricks as a Transactional System with .NET App

usman_naseem
New Contributor

Hello everyone,

We are currently facing performance issues when using Databricks as a transactional system with our .NET application via the Simba ODBC driver. Specifically, queries are taking 30 seconds to 1 minute to insert data into 8 to 10 tables, each having max to 400 records.

We also tested the Cdata ODBC and Cdata ADO.NET drivers for a proof of concept, but the results were not satisfactory. (https://www.cdata.com/drivers/).

Given the situation, we are considering switching to PostgreSQL as the transactional system for our .NET application, and then implementing a nightly data pipeline to incrementally load data from PostgreSQL into Databricks.

Before making this change, we would appreciate any suggestions on how we might improve performance with the current setup. Alternatively, do you think switching to PostgreSQL as the transactional system is the best approach?

Your expert opinions would be greatly appreciated. Thank you!

 

0 REPLIES 0

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local community—sign up today to get started!

Sign Up Now