Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
171 views
in Technique[技术] by (71.8m points)

Why SQL Server arcgis table data is not update when arcgis rest update data?

Arcgis server version 10.2, we try to get arcgis data directly from SQL Server, before we have been through arcgis provided by the rest interface call.

However, as the number of data gradually increased from 1600 to 6000, we found that the response data became very slow.

So I tried to connect directly to the table inside SQL Server to get data, which successfully solved the problem of slow data receiving.

Strangely, in our 10 experiments, we modified and queried the data through the ArcGIS REST interface, and all showed success without any problems.But the table inside SQL Server where the layer details are stored, has only been modified in real time once.

We began to wonder if ArcGIS REST has a caching mechanism that caches the user's data out of sync with the changes in the database.However, the problem that SQL Server data does not change after arcgis rest modification cannot be solved up to now


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)
等待大神答复

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

1.4m articles

1.4m replys

5 comments

56.8k users

...