QGIS - Scanning speed of MSSQL ConnectionQGIS and SQL Server Spatial Tables PerformanceWhy are OGR (MySQL /...
Why does Async/Await work properly when the loop is inside the async function and not the other way around?
Reply 'no position' while the job posting is still there
How do I implement a file system driver driver in Linux?
Do the concepts of IP address and network interface not belong to the same layer?
Count the occurrence of each unique word in the file
Proving a function is onto where f(x)=|x|.
About a little hole in Z'ha'dum
Divine apple island
Is it possible to have a strip of cold climate in the middle of a planet?
Why do IPv6 unique local addresses have to have a /48 prefix?
Greco-Roman egalitarianism
Open a doc from terminal, but not by its name
List of people who lose a child in תנ"ך
How must one send away the mother bird?
Why did the HMS Bounty go back to a time when whales are already rare?
What (else) happened July 1st 1858 in London?
Should I stop contributing to retirement accounts?
Can somebody explain Brexit in a few child-proof sentences?
THT: What is a squared annular “ring”?
anything or something to eat
A Permanent Norse Presence in America
Two-sided logarithm inequality
We have a love-hate relationship
What major Native American tribes were around Santa Fe during the late 1850s?
QGIS - Scanning speed of MSSQL Connection
QGIS and SQL Server Spatial Tables PerformanceWhy are OGR (MySQL / PostGIS) connections extremely slow in QGIS 2.0 - 2.8 (when compared to QGIS 1.8)?Optimising performance on local QGIS + PostGIS installation?Why does deleting columns in the QGIS attribute table take longer than in ArcGIS?Speeding up connection to MS SQL Server in QGIS?'use estimated metadata' doesn't work in QGIS 2.14, 2.16; metadata queries of deathPostGIS Shapefile DBF Loader 2.2 in pgAdmin III greyed out - why?QGIS 2.18.10 getting slower after 3 months?Offline editing solution for small GIS project with multiple editors?QGIS startup - slow loading composers
I notice in QGIS (currently using 3.4.2) when connecting to a SQL database it takes a while to load all of the layers as it scans through the database, meaning if I go to select a feature to drag into QGIS I still have to wait until the entire database is loaded. Is there a way of speeding this up? We have quite a few features in our GIS databases which it has to load.
qgis
add a comment |
I notice in QGIS (currently using 3.4.2) when connecting to a SQL database it takes a while to load all of the layers as it scans through the database, meaning if I go to select a feature to drag into QGIS I still have to wait until the entire database is loaded. Is there a way of speeding this up? We have quite a few features in our GIS databases which it has to load.
qgis
add a comment |
I notice in QGIS (currently using 3.4.2) when connecting to a SQL database it takes a while to load all of the layers as it scans through the database, meaning if I go to select a feature to drag into QGIS I still have to wait until the entire database is loaded. Is there a way of speeding this up? We have quite a few features in our GIS databases which it has to load.
qgis
I notice in QGIS (currently using 3.4.2) when connecting to a SQL database it takes a while to load all of the layers as it scans through the database, meaning if I go to select a feature to drag into QGIS I still have to wait until the entire database is loaded. Is there a way of speeding this up? We have quite a few features in our GIS databases which it has to load.
qgis
qgis
asked 3 mins ago
Joshua J GeogheganJoshua J Geoghegan
5418
5418
add a comment |
add a comment |
0
active
oldest
votes
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%2f316518%2fqgis-scanning-speed-of-mssql-connection%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f316518%2fqgis-scanning-speed-of-mssql-connection%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