[Qgis-user] Re.Very slow adding MapInfo tables

[Morgan, David]

If you have received this email in error, please notify us by telephone on 01437 764551 and delete it from your computer immediately. Os ydych chi wedi derbyn yr e-bost hwn trwy gamgymeriad, byddwch cystal â rhoi gwybod inni trwy ffonio 01437 764551. Wedyn dylech ddileu’r e-bost ar unwaith oddi ar eich cyfrifiadur.


Graham

I think it's a spatial index problem, because QGIS doesn't use MapInfo's
.ID file it has to load the complete table before displaying anything.
I've only had this problem with OS MasterMap (UK) data and worked round
it by saving the data as a shapefile, loading it into QGIS (which will
still take a long time at first), and creating a spatial index in QGIS.
After this it will load quickly. Another work around is loading the data
into SQL Server (QGIS2.0 can read sql server spatial indexes), I think
this approach will also work with PostGIS.

Dave

Date: Thu, 12 Dec 2013 09:01:20 -0800 (PST)
From: Graham <gford2113 at outlook.com>
To: qgis-user at lists.osgeo.org
Subject: [Qgis-user] Very slow adding MapInfo tables
Message-ID: <1386867680177-5094016.post at n6.nabble.com>
Content-Type: text/plain; charset=us-ascii

Hi,
I'm adding native MapInfo tables to a project in QGIS 2.0.1.  Small
tables
are fine, but tables with around 2 million records take 20 minutes to
add! 
Likewise opening the Attribute table takes a very long time.

One a large table has been added, the map performs well - panning and
zooming function really quickly.

Is there anything I can do to achieve acceptable loading times?

Cheers

Graham


**************************************************************************************************************

This document should only be read by those persons to whom it is addressed, and be used by them for its intended purpose; and must not otherwise be reproduced, copied, disseminated, disclosed, modified, distributed, published or actioned. If you have received this email in error, please notify us immediately by telephone on 01437 764551 and delete it from your computer immediately. This email address must not be passed on to any third party nor be used for any other purpose.

Pembrokeshire County Council Website - http://www.pembrokeshire.gov.uk

Please Note: Incoming and outgoing e-mail messages are routinely monitored for compliance with our IT Security, and Email/Internet Policy.

This signature also confirms that this email message has been swept for the presence of computer viruses and malicious code.

***************************************************************************************************************

Dim ond y sawl y mae'r ddogfen hon wedi'i chyfeirio atynt ddylai ei darllen, a'i defnyddio ganddynt ar gyfer ei dibenion bwriadedig; ac ni ddylid fel arall ei hatgynhyrchu, copio, lledaenu, datgelu, addasu, dosbarthu, cyhoeddi na'i rhoi ar waith chwaith. Os ydych chi wedi derbyn yr e-bost hwn trwy gamgymeriad, byddwch cystal a rhoi gwybod i ni ar unwaith trwy ffonio 01437 764551 a'i ddileu oddi ar eich cyfrifiadur ar unwaith. Ni ddylid rhoi'r cyfeiriad e-bost i unrhyw drydydd parti na'i ddefnyddio ar gyfer unrhyw ddiben arall chwaith.

Gwefan Cyngor Sir Penfro - http://www.pembrokeshire.gov.uk

Sylwer: Mae negeseuon e-bost sy’n cael eu hanfon a’u derbyn yn cael eu monitro’n rheolaidd ar gyfer cydymffurfio â’n Diogelwch TG, a’n Polisi E-bost/Rhyngrwyd.

Mae'r llofnod hwn hefyd yn cadarnhau bod y neges e-bost hon wedi cael ei harchwilio am fodolaeth firysau cyfrifiadurol a chod maleisus.

***************************************************************************************************************

 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20131213/5ac448eb/attachment.html>