Hey Steven, Just checking up to see how you got on with the speed ups I added for MS SQL layers?
- Nathan On Wed, Jul 3, 2013 at 8:42 AM, Nathan Woodrow <[email protected]> wrote: > Hey Steven, > > Yes it will. > > Regards, > Nathan > > > On Wed, Jul 3, 2013 at 12:45 AM, Steven Campbell > <[email protected]>wrote: > >> 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**** >> >> *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
