Datasnap or RemoteSQL or RemoteDB or?

[shimo]

One of the biggest trends in IT today is moving database to the cloud. Well, ok, great, but what about performance??

My Delphi app yesterday connected direct to database trough plain anydac connection. Now my database is in the cloud and
transfer of data became ridiculously slow. I found some of the products that can help me to boost my app.

- Datasnap
- RemoteSQL
- RemoteDB

Do you have any experience/suggestions about these products?

Don't tell me that i need to reduce amount of data that i am transfering :-D

Thanks. :thumb:

[mkinzler]

Which cloud platform? Which dbms?

[shimo]

MSSQL, Azure. But the same thing is with amazon...

[mkinzler]

http://docwiki.embarcadero.com/RADSt...d_Applications

[shimo]

Thx mkinzler.

Ok, i wonder how this would work and what i have to do. My app consists of "documents". Document is a collection of datasets. When i open a document, i
create multiple datasets and give them some SQL command. I would like to keep the structure of application the same (datasets).
Can i just replace direct connection with lets say some kind of connection to cloud service? Firedac provides this?

[mkinzler]

FireDAC ist the successor of AnyDAC. This can be done through one of the mentioned solutions. If you have an enterprise version of delphi you can use DataSnap. If not I would try both of them.
There are possibly other products worth a look.

http://www.fmxexpress.com/automatica...droid-and-ios/

All Rest(ful) server solutions could be used

http://www.delphipraxis.net/184570-e...-new-post.html

[shimo]

Thx. I will take a look this links. :thumb:

I do see quite "spits" and bad comments about DataSnap arround (memory problems, speed). Any real experience with it?
Those other two components are new? How about them?

[Sir Rufo]

Crosspost

[shimo]

The more poples you ask, the posibility that you will get the right answer is increasing :-D

[mkinzler]

Zitat:

Zitat von shimo (Beitrag 1296907)

The more peoples you ask, the possibility that you will get the right answer is increasing :-D

But you should advertise this