Access to external data (DataDirect Cloud to Azure) is very slow - Forum - Rollbase - Progress Community

Access to external data (DataDirect Cloud to Azure) is very slow

 Forum

Access to external data (DataDirect Cloud to Azure) is very slow

This question is not answered

Hello,

  I have a simple databse in azur. I create datacloud direct on sqlserver database.

On rollbase in private cloud mode, create a new object with a id and 5 field.

to show 20 rows, rollbase take 60 sec while in c# programme in same machine directly acces at database take 1sec for 200 rows.

Is it normal ?

All Replies
  • Rollbase is creating the connect and then getting the data.  It is normally the connection creation that is slow.  

    For C# are you using ODBC to go through DataDirect Cloud (DDC)?   (Or did you try the datadirect cloud access directly from the SQL Tester -- you might see a similar 'connection' taking a while to start up the tester and then a faster part for the SQL query itself.    One other question is the "Force Refresh" setting you have on the advanced tab in DDC.

  • I use in c# sql azur provider. i try directly with SQL Tester and i have good perfomance