Query service vs query DB

524
4
03-19-2019 02:04 AM
ClémentLaskar
New Contributor III

Hello,

I would like to know if it faster to query a DB from a service or to query it directly without using the Query object from the JS API. Is there any doc on this topic ?

Thanks,

Clément

0 Kudos
4 Replies
RobertScheitlin__GISP
MVP Emeritus

Clement,

   What exactly do you mean by

if it faster to query a DB from a service

?

0 Kudos
ClémentLaskar
New Contributor III

Hello Robert,

Sorry I was not clear. I have an Oracle DB with a SDE scheme. Does it causes high latency raise to publish its tables on an ArcGIS Server and then query the associated service (with let's say the JS API) ? Or should I prefer to directly query my DB with a server-side langage like Java ?

Thanks a lot.

Clément

0 Kudos
RobertScheitlin__GISP
MVP Emeritus

Clement,

   I have not seen any documents with stats on this but I would say they are very similar in response. But native will always have an edge.

ClémentLaskar
New Contributor III

Okay thank you Robert !

0 Kudos