Layers render very slowly when importing from sql The Next CEO of Stack OverflowCan Mapnik...
Why here is plural "We went to the movies last night."
What does this shorthand mean?
Putting a 2D region plot under a 3D plot
Why didn't Khan get resurrected in the Genesis Explosion?
How to get regions to plot as graphics
Can the Reverse Gravity spell affect the Meteor Swarm spell?
I believe this to be a fraud - hired, then asked to cash check and send cash as Bitcoin
Why did we only see the N-1 starfighters in one film?
Why is there a PLL in CPU?
Return the Closest Prime Number
Apart from "berlinern", do any other German dialects have a corresponding verb?
Natural language into sentence logic
What can we do to stop prior company from asking us questions?
How to write the block matrix in LaTex?
Why doesn't a table tennis ball float on the surface? How do we calculate buoyancy here?
Anatomically Correct Strange Women In Ponds Distributing Swords
Only print output after finding pattern
How to write papers efficiently when English isn't my first language?
What is meant by a M next to a roman numeral?
If I blow insulation everywhere in my attic except the door trap, will heat escape through it?
Is a stroke of luck acceptable after a series of unfavorable events?
Go Pregnant or Go Home
How easy is it to start Magic from scratch?
Is the concept of a "numerable" fiber bundle really useful or an empty generalization?
Layers render very slowly when importing from sql
The Next CEO of Stack OverflowCan Mapnik render spatial data from SQL Server?Using MS SQL 2005 as the data store in GeoServerWhat program(s) can I use to edit a boundary?Importing shapefiles to SQL ServerBug when viewing data from SQL Server in QGISIssues importing feature class to SDE SQL Server 2012Query Data from an Event Table in ArcGIS (Linear Referencing)Reverse geocoding from sql serverProblem with adding non spatial view from MSSQL to QGISImporting Shapefile geometry into SQL Server 2016
I am trying to get a handle on importing layers into qgis 2.6 using the "Add MSSQL Spatial Layer" option. I was able to import a layer successfully, but it seems to take a long time to render. Is there a way to handle layers from a database more efficiently? Are there plugins that you would recommend? Also, would it be better to use a Postgres server and add "PostGIS Layers" as opposed to what is being done now, which is adding mssql spatial layers through an Azure DB connection?
sql-server qgis-2.6
asked Apr 22 '15 at 14:10
MatthewMatthew
295
bumped to the homepage by Community♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I am trying to get a handle on importing layers into qgis 2.6 using the "Add MSSQL Spatial Layer" option. I was able to import a layer successfully, but it seems to take a long time to render. Is there a way to handle layers from a database more efficiently? Are there plugins that you would recommend? Also, would it be better to use a Postgres server and add "PostGIS Layers" as opposed to what is being done now, which is adding mssql spatial layers through an Azure DB connection?
sql-server qgis-2.6
asked Apr 22 '15 at 14:10
MatthewMatthew
295
bumped to the homepage by Community♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I am trying to get a handle on importing layers into qgis 2.6 using the "Add MSSQL Spatial Layer" option. I was able to import a layer successfully, but it seems to take a long time to render. Is there a way to handle layers from a database more efficiently? Are there plugins that you would recommend? Also, would it be better to use a Postgres server and add "PostGIS Layers" as opposed to what is being done now, which is adding mssql spatial layers through an Azure DB connection?
sql-server qgis-2.6
asked Apr 22 '15 at 14:10
MatthewMatthew
295
I am trying to get a handle on importing layers into qgis 2.6 using the "Add MSSQL Spatial Layer" option. I was able to import a layer successfully, but it seems to take a long time to render. Is there a way to handle layers from a database more efficiently? Are there plugins that you would recommend? Also, would it be better to use a Postgres server and add "PostGIS Layers" as opposed to what is being done now, which is adding mssql spatial layers through an Azure DB connection?
sql-server qgis-2.6
sql-server qgis-2.6
asked Apr 22 '15 at 14:10
MatthewMatthew
295
asked Apr 22 '15 at 14:10
MatthewMatthew
295
asked Apr 22 '15 at 14:10
MatthewMatthew
295
asked Apr 22 '15 at 14:10
MatthewMatthew
295
asked Apr 22 '15 at 14:10
MatthewMatthew
295
295
bumped to the homepage by Community♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Hi have you tried adding a spatial index to your DB?
to add a spatial index : Docs
After if the vector layer has a important number of elements, you can choose to display your objects depending on the level of zoom:
In layerProperties -> General
answered Apr 22 '15 at 14:27
julsbreakdownjulsbreakdown
1,214618
Juls, thanks for your response. Yes, I have already added a spatial index to the DB. Also, the current layer we are working with is not complex at all. Its just a shapefile with 56 elements in it.
– Matthew
Apr 22 '15 at 14:29
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "79"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f143565%2flayers-render-very-slowly-when-importing-from-sql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Hi have you tried adding a spatial index to your DB?
to add a spatial index : Docs
After if the vector layer has a important number of elements, you can choose to display your objects depending on the level of zoom:
In layerProperties -> General
answered Apr 22 '15 at 14:27
julsbreakdownjulsbreakdown
1,214618
Juls, thanks for your response. Yes, I have already added a spatial index to the DB. Also, the current layer we are working with is not complex at all. Its just a shapefile with 56 elements in it.
– Matthew
Apr 22 '15 at 14:29
add a comment |
Hi have you tried adding a spatial index to your DB?
to add a spatial index : Docs
After if the vector layer has a important number of elements, you can choose to display your objects depending on the level of zoom:
In layerProperties -> General
answered Apr 22 '15 at 14:27
julsbreakdownjulsbreakdown
1,214618
Juls, thanks for your response. Yes, I have already added a spatial index to the DB. Also, the current layer we are working with is not complex at all. Its just a shapefile with 56 elements in it.
– Matthew
Apr 22 '15 at 14:29
add a comment |
Hi have you tried adding a spatial index to your DB?
to add a spatial index : Docs
After if the vector layer has a important number of elements, you can choose to display your objects depending on the level of zoom:
In layerProperties -> General
answered Apr 22 '15 at 14:27
julsbreakdownjulsbreakdown
1,214618
Hi have you tried adding a spatial index to your DB?
to add a spatial index : Docs
After if the vector layer has a important number of elements, you can choose to display your objects depending on the level of zoom:
In layerProperties -> General
answered Apr 22 '15 at 14:27
julsbreakdownjulsbreakdown
1,214618
answered Apr 22 '15 at 14:27
julsbreakdownjulsbreakdown
1,214618
answered Apr 22 '15 at 14:27
julsbreakdownjulsbreakdown
1,214618
answered Apr 22 '15 at 14:27
julsbreakdownjulsbreakdown
1,214618
1,214618
Juls, thanks for your response. Yes, I have already added a spatial index to the DB. Also, the current layer we are working with is not complex at all. Its just a shapefile with 56 elements in it.
– Matthew
Apr 22 '15 at 14:29
add a comment |
Juls, thanks for your response. Yes, I have already added a spatial index to the DB. Also, the current layer we are working with is not complex at all. Its just a shapefile with 56 elements in it.
– Matthew
Apr 22 '15 at 14:29
Juls, thanks for your response. Yes, I have already added a spatial index to the DB. Also, the current layer we are working with is not complex at all. Its just a shapefile with 56 elements in it.
– Matthew
Apr 22 '15 at 14:29
Juls, thanks for your response. Yes, I have already added a spatial index to the DB. Also, the current layer we are working with is not complex at all. Its just a shapefile with 56 elements in it.
– Matthew
Apr 22 '15 at 14:29
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f143565%2flayers-render-very-slowly-when-importing-from-sql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
