Hi Nathan
Many Thanks Will this be available in the nightly builds of QGIS? Thanks Steve From: Nathan Woodrow [mailto:[email protected]] Sent: 02 July 2013 04:02 To: Steven Campbell Cc: qgis-user Subject: Re: [Qgis-user] OS Mastermap, SQL Server and QGIS Hey Steven, I have made the change in master now too allow QGIS too look in the spatial index table for faster extent loading. Works like a treat. I would still have the geometry_columns table to allow QGIS to find the tables quicker but you don't need the max_x, etc stuff. Thanks for the tip. Regards, Nathan On Sat, Jun 29, 2013 at 12:00 AM, Steven Campbell <[email protected]> wrote: Hi Does anyone else have significant time delays when trying to open large datasets from a SQL database in QGIS? I have uploaded my Ordnance survey MasterMap data (coverage is the size of an average English County) and although the initial connection to identify the table is very quick, the loading of the table (even when zoomed in to a very big scale (i.e. 1:100) it takes a very long time to open. Once opened the speed is very quick, but getting it to open takes a lot of patience as the application appears to hang. On a slightly related topic, if I have connected to one MSSQL database, QGIS then struggles if I try to connect to an additional database, again it just appears to hang for a considerable period of time (30 minutes or more at times), it seems odd especially as the connection to the first SQL database is almost instant.... Any suggestions as to how I can improve this speed would be greatly appreciated. Thanks Steve Campbell GIS Manager Corporate Strategy and Communications Borough of Poole | Civic Centre | Poole BH15 2RU Tel: 01202 633 362 Email: [email protected] Website:www.boroughofpoole.com <http://www.boroughofpoole.com/> Think Green! Please Recycle DISCLAIMER: This email and any files transmitted with it may be confidential, legally privileged and protected in law and are intended solely for the use of the individual to whom it is addressed. The copyright in all documentation is the property of the Borough of Poole and this email and any documentation must not be copied or used other than as strictly necessary for the purpose of this email, without prior written consent which may be subject to conditions. Any view or opinions presented are solely those of the author and do not necessarily represent those of the Borough of Poole. The Borough of Poole reserves the right to inspect incoming and outgoing emails. If you have received this email in error please contact the sender by return and confirm that its contents have been destroyed. Telephone enquiries should be directed to the Borough switchboard on 01202 633633. _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user DISCLAIMER: This email and any files transmitted with it may be confidential, legally privileged and protected in law and are intended solely for the use of the individual to whom it is addressed. The copyright in all documentation is the property of the Borough of Poole and this email and any documentation must not be copied or used other than as strictly necessary for the purpose of this email, without prior written consent which may be subject to conditions. Any view or opinions presented are solely those of the author and do not necessarily represent those of the Borough of Poole. The Borough of Poole reserves the right to inspect incoming and outgoing emails. If you have received this email in error please contact the sender by return and confirm that its contents have been destroyed. Telephone enquiries should be directed to the Borough switchboard on 01202 633633.
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
