Performance of REST API calls vs direct DB connection using scripts


#1

Hi,

I am a newbie. I just came to know about dreamfactory which is sounding very good.

I would like to know which one gives better performance in the following:

  • Getting data using REST API calls in webapps OR
  • Getting data directly using scripts in webapps

Please suggest.

Thanks
Gowtham


#2

Gowtham,

Could you give some context as to what your application(s) is going to do? If you give me a scenario I can feel out the more efficient method for you.

Thanks,

  • Mark

#3

Hi Mark,

Thank you for your reply.

I am trying to build an enterprise oriented SaaS application.

We planned to build using PHP + MySql. After learned about dreamfactory, we are thinking of using html5 + angularJs + REST APIs using dreamfactory.

I would like to know if the performance remains same like normal direct connection based connections vs REST API calls based application.

Please let me know if need additional information.

Looking forward to hear your suggestions.

Thanks
Gowtham


#4

Gowtham,

Sounds good. As far as comparison between REST and direct connection, latency is about 250 ms. So, very small (almost unnoticeable) difference.

From what you’ve said, it looks like this would be a good fit. I would suggest definitely giving it a try and if you need more info you can always email me direct mark@dreamfactory.com.

Thanks,

  • Mark

#5

Sure Mark!

Thank you very much for your response.

Could you please share any enterprise applications built using dream factory APIs?

Thanks
Gowtham


#6

Hi Gowtham,

For enterprise examples check out DreamTeam, there are 20,000 companies using in on salesforce, i ported to DSP

This is a rich client app, with 350 + connections to back end SQL DB

Let us know if you have any trouble

https://github.com/dreamfactorysoftware/app-dreamteam

Bill