topic Re: Query service vs query DB in ArcGIS JavaScript Maps SDK Questions

Query service vs query DB

ClémentLaskar — Tue, 19 Mar 2019 09:04:30 GMT

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

Re: Query service vs query DB

RobertScheitlin__GISP — Tue, 19 Mar 2019 12:39:40 GMT

Clement,

What exactly do you mean by

if it faster to query a DB from a service

Re: Query service vs query DB

ClémentLaskar — Thu, 21 Mar 2019 08:57:36 GMT

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

Re: Query service vs query DB

RobertScheitlin__GISP — Thu, 21 Mar 2019 13:10:30 GMT

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.

Re: Query service vs query DB

ClémentLaskar — Thu, 21 Mar 2019 14:15:05 GMT

Okay thank you Robert !