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 ?
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