Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2015
    Posts
    2

    Question Unanswered: Datasnap or RemoteSQL or RemoteDB or?

    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

    Thanks.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    is the delay a function of connecting to the cloud (IE any and every attempt to connect to any cloud db will be 'that' slow)
    or
    is the delay inherent in your current cloud providers set up (and you need to find a more resonsive cloud db server.
    or
    is the delay due to your network infrastructure not sufficiently 'tuned' to connect to a high traffic external service (it coudl be you need to re examine all links fromt he application via network switches, firewwlls, external routers and so on.

    Ive no doubt that conencting to remote cloud db will be slower than say on a local server connected to your intranet using, say gigabit network connections
    before slinging cash at a solution Id want to know where the problem liurks, and try and identify the best fix for the costs invovled
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Apr 2015
    Posts
    2
    Well, there are for sure multiple problems. There is for sure problems with network infrastructure
    where clinet applications are located (ADSL - 1-5 Max Mbps)...

    I tried Azure and Amazon cloud services (database is MSSQL), and i don't think they have any problems with speed...
    There is for sure problem with excessive database communication and transferring large amounts of data.
    And there is a problem that i can't afford now to change my application structure.

    I read on that RemoteSQL site about latency issues. Could this be my problem? Or is it just a convenient marketing play?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •