nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is there a performance loss on a service containing a definition query?

BrandonKeinath1

It looks like I am able to publish services from data that contain definition queries. Is there any performance loss doing it this way rather than a separate exported feature class? You could also expand it to me wondering what the pros/cons are for publishing services with definition queries.

Thanks,

Brandon

Trouver plus de publications taguées avec

Accepted answers

XanderBakker

I guess it will be pretty fast if you set the right indexes, but publishing he data the corresponds to the query only, will probably be a little faster.

All comments

XanderBakker

The fields you are referencing in the query should have an attribute index to query data on attributes faster:

ArcGIS Help (10.2, 10.2.1, and 10.2.2)

BrandonKeinath1

Hi Xander,

Which indexes should I be on the look out for?

Brandon

XanderBakker

I guess it will be pretty fast if you set the right indexes, but publishing he data the corresponds to the query only, will probably be a little faster.

BrandonKeinath1

Giving this a boost to see if anyone has any opinions. I successfully published a service with a definition query but still looking to see what effects this might have long term

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.