Workflow Autocomplete slow
I have a workflow that uses an autocomplete drop down. It was working fine for many months, and now it takes up to 1 minute for it to populate. Can someone give me some suggestions on how to figure out why and then fix?
0
-
Hi Paul
could you tell us a little more about the source of the items for the autocomplete?
Where do they come from?
How many items are in there etc.
Regards
Ralph0 -
Hi Paul,
I would look out for a couple things if there was little or no change in the numbers of records. My first thought is looking at the index (or adding one if not present). If present, it may need to be rebuilt or the feature class may need to be analyzed. I also try to avoid bringing back too many records. I normally make the user enter 3 characters before showing any choices. Hope those ideas help.
Dave0 -
The source is a line layer in a file geodatabase based mapservice that has a ROADNAME attribute. It is indexed and I don't allow it to autocomplete until 3 characters. There are 1182 features.
The feature class gets updated everynight through FME from our development environment to our web environment.
Thanks.0 -
Any further ideas or thoughts? 0 -
Hi there Paul,
You could try running Fiddler or your browser's developer tools, and looking at the timings to see exactly which request it's slowing down on. From there, I would check those timings against the logs from your geodatabase server, to see how long it's taking to complete the query. That will tell you if it's a problem at the web level, or the database level.
I hope this helps! If you're still having trouble, I would suggest opening a support case, so one of the analysts can assist you.
Cheers,
Danny0 -
Hi Paul, I was wondering if you every got your autocomplete running faster...we are having a similiar issue at the moment... 0 -
Yes - I recreated and reindexed the tables that the autocomplete was drawing on and it sped everything up. It's now instantaneous. 0
Du måste logga in om du vill lämna en kommentar.
Kommentarer
7 kommentarer