[Qgis-user] OS Mastermap, SQL Server and QGIS

[Steven Campbell]

Hi Nathan

To be honest, I had problems installing the nightly master copy, so I'll wait till next week for the weekly build to test it.

I'll let you know how I get on

Thanks again

Steve

Sent from my Sony Xperia™ smartphone

Nathan Woodrow <madmanwoo at gmail.com> wrote:

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 <madmanwoo at gmail.com> wrote:

> Hey Steven,
>
> Yes it will.
>
> Regards,
> Nathan
>
>
> On Wed, Jul 3, 2013 at 12:45 AM, Steven Campbell <s.campbell at poole.gov.uk>wrote:
>
>> Hi Nathan****
>>
>> ** **
>>
>> Many Thanks****
>>
>> ** **
>>
>> Will this be available in the nightly builds of QGIS?****
>>
>> ** **
>>
>> Thanks****
>>
>> ** **
>>
>> Steve****
>>
>> ** **
>>
>> *From:* Nathan Woodrow [mailto:madmanwoo at gmail.com]
>> *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 <
>> s.campbell at poole.gov.uk> 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: s.campbell at poole.gov.uk****
>>
>> 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
>> Qgis-user at lists.osgeo.org
>> 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.
>>
>
>