Query service vs query DB

Question

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

ClémentLaskar · Answer

Okay thank you Robert !

rscheitlin · Answer

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 · Answer

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