Delayed SQL based map tips

Permanently deleted user

12 Augusti 2016 18:26

This is related to buidling in data connections off of SQL queries for map tips. i have created a map tip that ties into a one to one SQL Count  data link. This query works and displays the count query as expected(See below)

 

But the issue is, that is takes 4-6 seconds to kick in after my map tip is opened and displayed. Is there anything i can do speed this process up so that to the user, it doesn't appear as though this count fucniton is dealayed and shows up willy nilly? I am open to db configuration or any other configurations in which this process is sped up significantly. Thanks in advance.

0

• 

  Dan Griffin

  12 Augusti 2016 19:10

  I noticed a delay in maptips referencing SQL data (spatial views) after upgrading from ArcGIS Server 10.3 to 10.4.1.  Hopefully, this is fixed in the upcoming release of Geocortex. 

  0
• 

  Permanently deleted user

  15 Augusti 2016 15:38

  Sorry image didn't come through. Here it is again.

  0
• 

  Permanently deleted user

  18 Augusti 2016 21:39

  Hi Raoul,

   

  Can we try to narrow down where the delay is coming from?  Here's what I would suggest:

   

  1) Run fiddler or your browser's dev tools, and look at the timings.  Is there a particular request that's taking a long time to complete?

   

  2) Check your logs on your SQL server and see how long your query is taking to complete

   

  3) If you can't find that in the logs, try executing the query manually using SQL Studio, or something similar.  Do you see the same slow results?

   

  It's possible that the problem could be on the SQL server, or the web level.  It's hard to say without some more information.  

   

  I hope this helps!  If it doesn't please let me know here, or you can open a support case, and one of the other analysts or myself can assist you.

   

  Cheers!

   

  Danny

  0

Du måste logga in om du vill lämna en kommentar.