Bug report #12923
Project with SQL Server Layers opens much slower in 2.8 than 2.6
|Affected QGIS version:||2.8.2||Regression?:||No|
|Operating System:||Windows||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||no timely feedback|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||21006|
I have a project that contains many sql server layers. In version 2.6 it opened in about 20 seconds in version 2.8.1 it takes about 100. I note a difference with even one layer taking considerably longer in 2.8.
Windows 7 64bit desktop
SQL Server 12 on Windows Server 12
#5 Updated by Jason Moore about 5 years ago
Most are not very complex. Two or three joined tables, one always being the feature table which has a unique int column that is the primary key for that table and also contains the geometry. An example would be a view called QGIS_SAN_MHs, it contains three inner joined tables, SAN_MHs, DPW_DrainageStructures, and DAT_Features. All are linked on the fetID column which is primary int in DAT_Features.
#9 Updated by Jürgen Fischer over 1 year ago
- Resolution set to no timely feedback
- Status changed from Feedback to Closed
Bulk closing 82 tickets in feedback state for more than 90 days affecting an old version. Feel free to reopen if it still applies to a current version and you have more information that clarify the issue.