<div>Hi Jürgen,</div><div>Thanks again for this. I've now had the chance to do a little playing with it. And have some feedback below (along with the already-filed tickets).</div><div><br></div><div>My primary observation is that its slow I'm afraid.</div>
<div><br></div><div>-----</div><div><br></div><div>The first and most obvious thing is that it's incredibly slow to list the tables. I don't know how many tables were used in the test setup, but we have over a thousand spatial tables ranging from one row to 20 million on an Oracle Locator 10g setup that has about 50 concurrent users.</div>
<div><br></div><div>In the best case scenario ("Only look in meta data table" and "Use estimated table metadata" both checked), it still takes a full <b>two minutes</b> to list all of the tables. If I don't have those checkboxes checked it takes much longer (scanning the table that has ~20million features alone takes about a minute!).</div>
<div><br></div><div>Does QGIS need to do all of the checks it does when actually listing the tables? Could it not do them when they are selected for adding instead? We have half a dozen other GIS program's that connect to Oracle and none of them are even close to being this slow to produce the table list.</div>
<div><br></div><div>Its also impossible to "add" a table while the list is being generated so the user has to wait until its finished before being able to continue. Though it does seem to get a little faster on subsequent requests, even restarting QGIS, but that's probably Oracle caching.</div>
<div><br></div><div>Note: I'm aware ArcGIS uses its ArcSDE tables and MapInfo uses its own metadata table so its not an /entirely/ fair comparison.</div><div><br></div><div>-----</div><div><br></div><div>If I click "add" for a polygon dataset with ~7 million features (fully indexed), it takes a full 90 seconds before it is even added to QGIS (during this time QGIS is unresponsive)! This is with rendering turned off.</div>
<div>The 20 million polyline dataset takes 140 seconds to add, again, with rendering off!</div><div><br></div><div>This is less noticeable with smaller datasets.</div><div><br></div><div>-----</div><div>Panning. Again, fine with smaller datasets, but the larger ones cause issues.</div>
<div>The larger dataset (20 million features) is MasterMap Topographic Line, the large scale mapping for the UK. If I view it at 1:5,000 (the furthest out we use it), there are in a detailed urban scene about 40,000 features on-screen.</div>
<div><br></div><div>In order of speed:</div><div><br></div><div>QGIS: ~4-16 seconds (no styling))</div><div>GeoServer WMS "single tile" : ~15 seconds (via Openlayers, categorised styling)</div><div>MapInfo: ~9 seconds (includes categorised styling)</div>
<div>ArcGIS: ~4 seconds (includes categorised styling)</div><div>GeoServer WMS 256^2 tiled (no GWC cache): ~3 seconds (via Openlayers, categorised styled)</div><div><br></div><div>The panning did get faster, I guess because Oracle started picking up on my pans.</div>
<div><br></div><div>---</div><div>The short version is - is there anything I can do to speed this up? Are these the expected speeds for these sorts of datasets/numbers?<br></div><div><br></div><div>I'm happy to do further testing if desired.</div>
<div><br></div><div>Jonathan</div><div><br></div>
<br><br><div class="gmail_quote">On 9 May 2013 16:13, Jürgen E. <span dir="ltr"><<a href="mailto:jef@norbit.de" target="_blank">jef@norbit.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi Jonathan,<br>
<div class="im"><br>
On Wed, 08. May 2013 at 11:24:08 +0100, Jonathan Moules wrote:<br>
> Anyone? I'd love to try this and test it, but can't if I have no idea how<br>
> to even connect. Is there any documentation for it anywhere?<br>
<br>
</div><a href="https://github.com/qgis/Quantum-GIS/blob/master/resources/context_help/QgsOracleNewConnection-en_US" target="_blank">https://github.com/qgis/Quantum-GIS/blob/master/resources/context_help/QgsOracleNewConnection-en_US</a><br>
<br>
Jürgen<br>
<span class="HOEnZb"><font color="#888888"><br>
--<br>
Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-31<br>
Dipl.-Inf. (FH) Rheinstraße 13 Fax. +49-4931-918175-50<br>
Software Engineer D-26506 Norden <a href="http://www.norbit.de" target="_blank">http://www.norbit.de</a><br>
committ(ed|ing) to Quantum GIS IRC: jef on FreeNode<br>
<br>
--<br>
norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH<br>
Rheinstrasse 13, 26506 Norden<br>
GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502<br>
<br>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</font></span></blockquote></div><br>
<br>
<span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)">This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.</span>