Hexagon Geospatial
MENU

WebGIS

Need a push in the right direction when configuring WebMap, Portal or SDI services? Looking for hints and tips, or just looking for Ideas and information? The WebGIS discussion board is where you start those discussions, connect and share information.
Showing results for 
Search instead for 
Do you mean 
Reply
dal
Contributor
Posts: 39
Registered: ‎05-10-2016
Accepted Solution

Connection time differences between Access-Library and SQL-Server library --> what are the reasons?

Dear all,

 

When connecting to an Access-library with WebMap API, the connection times are significantly faster (some milliseconds) as compared to connecting to an SQLServer-library with WebMap API (1-3 seconds).

 

What are the reasons "behind the scenes" for this difference? From an absolute point of view, the difference is not that big; however, it is from a relative point of view.

 

Thank you.

Regards,

Dominik

Moderator
Posts: 245
Registered: ‎02-08-2016

Re: Connection time differences between Access-Library and SQL-Server library --> what are the re

Hi Dominik

 

 

Short version is that access is a local file system database where SQL Server uses a network interface.

There are numerous reasons that there are performance differences between the different warehouse connections.
It is dependent on the data location and the warehouse type.

 

If you want to research it further I would suggest looking into the Microsoft Jet Database Engine and SQL ADO.

 

 

Do you need immediate support?
If you encounter a critical issue and need immediate assistance please submit a Service Request through our Support Portal.