<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:BatangChe;
panose-1:2 3 6 9 0 1 1 1 1 1;}
@font-face
{font-family:"\@BatangChe";
panose-1:2 3 6 9 0 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Texte de bulles Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.hoenzb
{mso-style-name:hoenzb;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.TextedebullesCar
{mso-style-name:"Texte de bulles Car";
mso-style-priority:99;
mso-style-link:"Texte de bulles";
font-family:"Tahoma","sans-serif";
mso-fareast-language:FR;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=FR link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hi,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Yes !<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Unlike Oracle DB manager which, each time you run it, re-scan all schemas, the browse panel scan only one time.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Thanks a lot !<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'><o:p> </o:p></span></p><table class=MsoNormalTable border=1 cellpadding=0 style='border:none;border-top:solid gray 1.0pt'><tr style='height:54.95pt'><td width=294 style='width:220.5pt;border:none;padding:1.5pt 1.5pt 1.5pt 1.5pt;height:54.95pt'><p class=MsoNormal style='margin-left:21.3pt;text-indent:-21.3pt'><b><span lang=EN-US style='font-size:14.0pt;font-family:"Arial","sans-serif";color:#CC0066'>→</span></b><span lang=EN-US style='font-size:11.0pt;font-family:"Arial","sans-serif";color:#1F497D'> </span><b><span lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'>Sylvain PIERRE</span></b><b><span lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#CC0066'><o:p></o:p></span></b></p><p class=MsoNormal style='margin-left:21.3pt;text-indent:-21.3pt'><span lang=EN-US style='font-size:8.0pt;font-family:"Arial","sans-serif";color:#CC0066'> </span><span lang=EN-US style='font-size:8.0pt;font-family:"Arial","sans-serif";color:#1F497D'>Ingénieur Géographe<o:p></o:p></span></p><p class=MsoNormal style='margin-left:21.3pt;text-indent:-21.3pt'><span lang=EN-US style='font-size:8.0pt;font-family:"Arial","sans-serif";color:#1F497D'> Adjoint au chef du service<o:p></o:p></span></p><p class=MsoNormal style='margin-left:21.3pt;text-indent:-21.3pt'><span lang=EN-US style='font-size:8.0pt;font-family:"Arial","sans-serif";color:#1F497D'> Direction de l’Agriculture, de l’Espace Rural et de l’Environnement<o:p></o:p></span></p><p class=MsoNormal style='margin-left:21.3pt;text-indent:-21.3pt'><span lang=EN-US style='font-size:8.0pt;font-family:"Arial","sans-serif";color:#1F497D'> </span><span style='font-size:8.0pt;font-family:"Arial","sans-serif";color:#1F497D'>Service Administration Générale<o:p></o:p></span></p><p class=MsoNormal style='margin-left:21.3pt;text-indent:-21.3pt;line-height:115%'><span style='font-family:"Arial","sans-serif";color:navy'> </span><b><span style='font-size:8.0pt;line-height:115%;font-family:"Arial","sans-serif";color:#1F497D'>Conseil Général du Bas-Rhin</span></b><b><span style='font-size:8.0pt;line-height:115%;font-family:"Arial","sans-serif";color:navy'><o:p></o:p></span></b></p></td><td width=167 style='width:125.35pt;border:none;padding:1.4pt 1.4pt 1.4pt 1.4pt;height:54.95pt'><p class=MsoNormal align=center style='text-align:center;line-height:115%'><a href="http://www.bas-rhin.fr/"><span style='color:navy;text-decoration:none'><img border=0 width=152 height=72 id="Image_x0020_6" src="cid:image001.jpg@01CE7328.C1300980" alt="Description : Description : \\dsi7085103\c$\Users\samuel.guigon\Pictures\CG67\logo_CG67+www_coul.jpg"></span></a><span lang=EN-US style='font-size:8.0pt;line-height:115%;font-family:"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></p></td></tr><tr style='page-break-inside:avoid;height:54.95pt'><td width=463 colspan=2 style='width:347.35pt;border-top:solid gray 1.0pt;border-left:none;border-bottom:solid gray 1.0pt;border-right:none;padding:1.5pt 1.5pt 1.5pt 1.5pt;height:54.95pt'><p class=MsoNormal style='line-height:115%'><span style='font-size:8.0pt;line-height:115%;font-family:"Arial","sans-serif";color:gray'> </span><span lang=EN-US style='font-size:8.0pt;line-height:115%;font-family:"Arial","sans-serif";color:gray'>Passerelle 67 <br> 20 rue Livio / 67000 Strasbourg<br> Tél : +33 3 88 76 68 88 – mobile :<br> Fax : 03 88 76 68 71<br> Email : <a href="mailto:sylvain.pierre@cg67.fr">sylvain.pierre@cg67.fr</a><o:p></o:p></span></p></td></tr></table><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>De :</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> qgis-user-bounces@lists.osgeo.org [mailto:qgis-user-bounces@lists.osgeo.org] <b>De la part de</b> kimaidou<br><b>Envoyé :</b> jeudi 27 juin 2013 10:23<br><b>À :</b> Andreas Neumann<br><b>Cc :</b> qgis-user<br><b>Objet :</b> Re: [Qgis-user] QGIS and Oracle native connection<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal style='margin-bottom:12.0pt'>Hi <br><br>A suggestion : have you tried to use the Browser pannel ( in french : Menu Vue > Panneaux > Parcourir) or the DbManager to access the data ? With these 2 tools, you can very quickly navigate through databases, schemas and tables, without the need to wait for QGIS to scan them all.<o:p></o:p></p></div><div><p class=MsoNormal>Regards<o:p></o:p></p></div><div><p class=MsoNormal>Michael<o:p></o:p></p></div></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><div><p class=MsoNormal>2013/6/26 Andreas Neumann <<a href="mailto:a.neumann@carto.net" target="_blank">a.neumann@carto.net</a>><o:p></o:p></p><p class=MsoNormal>Hi,<br><br>I think this would be a very useful addition also for other database providers (Postgis, SQL server, etc.)<br><br>The problem is that we are in feature freeze now. Only bugfixes allowed at this time. New features (like this two-step scanning will have to wait for QGIS 2.0x or 2.1.<br><br>Andreas<o:p></o:p></p><div><p class=MsoNormal><br><br>On Wed, 26 Jun 2013 09:38:38 +0200, PIERRE Sylvain wrote:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm'><div><p class=MsoNormal style='margin-bottom:12.0pt'>Hi everybody,<br><br>I’ve installed Qgis-dev yesterday in order to test Oracle<br>connection.<br><br>I work in a french local government. 95% of our data are stored into<br>Oracle.<br><br>So this new connection looks very interesting for us.<br><br>The main things is definitively slowness at scanning DB.<br><br>We have more than 20 schema and users can’t wait that Qgis scans all<br>schemas until they can load their data.<br><br>I know you can stop scan BUT if unfortunatly you are interest in the<br>last one schema, you have to wait…<br><br>Is it possible to only list all schema in the UI and only scan data on<br>demand when user select a schema ?<br><br>Sylvain<o:p></o:p></p></div><p class=MsoNormal>→ SYLVAIN PIERRE<o:p></o:p></p><div><p class=MsoNormal style='margin-bottom:12.0pt'><br><br> Ingénieur Géographe<br><br> Adjoint au chef du service<br><br> Direction de l’Agriculture, de l’Espace Rural et<br>de l’Environnement<br><br> Service Administration Générale<o:p></o:p></p></div><p class=MsoNormal> CONSEIL GÉNÉRAL DU BAS-RHIN<br><br> [1]<o:p></o:p></p><div><p class=MsoNormal><br><br> Passerelle 67<br> 20 rue Livio / 67000 Strasbourg<br> Tél : <a href="tel:%2B33%203%2088%2076%2068%2088" target="_blank">+33 3 88 76 68 88</a> – mobile :<br> Fax : 03 88 76 68 71<o:p></o:p></p></div><p class=MsoNormal> Email : <a href="mailto:sylvain.pierre@cg67.fr" target="_blank">sylvain.pierre@cg67.fr</a> [2]<br><br>DE : <a href="mailto:qgis-user-bounces@lists.osgeo.org" target="_blank">qgis-user-bounces@lists.osgeo.org</a><br>[mailto:<a href="mailto:qgis-user-bounces@lists.osgeo.org" target="_blank">qgis-user-bounces@lists.osgeo.org</a>] DE LA PART DE Jonathan<br>Moules<br>ENVOYÉ : mardi 14 mai 2013 18:05<br>À : Jürgen E.; <a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a><br>OBJET : Re: [Qgis-user] QGIS and Oracle native connection<o:p></o:p></p><div><p class=MsoNormal style='margin-bottom:12.0pt'><br><br>Hi Jürgen,<br><br>I've updated to the newest nightly build (1.9.0-19 - yesterday) and<br>note it has a couple of fixes. Its also faster, in part because its<br>not listing the recycling tables now.<br><br>We have 551 rows in our all_sdo_geom_metadata table - seems we've had<br>a clean-up.<o:p></o:p></p><p class=MsoNormal>Can you work out which queries take particularly long (I added some<br>progress messages recently)?<o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'><br>I'm now using "only look in meta data table", "use estimated table<br>metadata" and "only existing geometry types" as my defaults.<br><br>In the bottom left there's something that says "Scanning column ... "<br>and then shows the column. The speed this cycles through tables seems<br>to vary - it goes blur-fast if I've just done it a minute ago (despite<br>restarting QGIS), so I guess in those cases Oracle caches - it only<br>takes < 5 seconds.<br><br>But if I do it for the first time, some of them take a significant<br>time, though it doesn't seem to be entirely related to their size (the<br>vast majority of the tables are only in the thousands of rows or<br>smaller - the millions are the exception (probably 5)).<o:p></o:p></p><p class=MsoNormal>You can "stop" the detection and then pick what's already there.<o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'><br>I completely missed the fact that "connect" turns into stop. Even took<br>me a minute after reading your email to find it.<br><br>Do you have<o:p></o:p></p></div><div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm'><p class=MsoNormal>re isn't any primary key) on<br>the client side.<br><br>Yes and no. Each table has a column with a unique number that is set<o:p></o:p></p></blockquote></div><p class=MsoNormal> be unique and not-nullable, but its not set as a primary key in<o:p></o:p></p><div><p class=MsoNormal><br>Oracle. MapInfo and ArcSDE use this column as their index (MapInfo<br>because its called MI_PRINX, and ArcSDE because we tell it to when we<br>register the table).<br><br>I don't know how normal this setup is, but the only other thing that's<br>ever hinted at wanting an explicit primary key is GeoServer, and then<br>only as a "WARN" event in the logs.<br><br>A thought - if it can't find a primary key, how about testing to see<br>if there's a column called MI_PRINX? Anywhere with MapInfo will have<br>it.<br><br><a href="http://testdrive.mapinfo.com/TECHSUPP/MIPROD.NSF/5c41496d5951a49c852562b5004f3a44/fcb3edc86ce9460b80256ae7004ee597" target="_blank">http://testdrive.mapinfo.com/TECHSUPP/MIPROD.NSF/5c41496d5951a49c852562b5004f3a44/fcb3edc86ce9460b80256ae7004ee597</a><o:p></o:p></p></div><p class=MsoNormal>[3]<br><br>Jonathan<br><br>On 14 May 2013 10:31, Jürgen E. wrote:<o:p></o:p></p><div><div><p class=MsoNormal><br><br>Hi Jonathan,<br><br>On Mon, 13. May 2013 at 13:06:49 +0100, Jonathan Moules wrote:<o:p></o:p></p><p class=MsoNormal>The first and most obvious thing is that it's incredibly slow to<o:p></o:p></p><p class=MsoNormal>list the<o:p></o:p></p><p class=MsoNormal>tables. I don't know how many tables were used in the test setup,<o:p></o:p></p><p class=MsoNormal>but we<o:p></o:p></p><p class=MsoNormal>have over a thousand spatial tables ranging from one row to 20<o:p></o:p></p><p class=MsoNormal>million on<o:p></o:p></p><p class=MsoNormal>an Oracle Locator 10g setup that has about 50 concurrent users.<br>In the best case scenario ("Only look in meta data table" and "Use<br>estimated table metadata" both checked), it still takes a full two<o:p></o:p></p><p class=MsoNormal>minutes<o:p></o:p></p><p class=MsoNormal>to list all of the tables. If I don't have those checkboxes checked<o:p></o:p></p><p class=MsoNormal>it<o:p></o:p></p><p class=MsoNormal>takes much longer (scanning the table that has ~20million features<o:p></o:p></p><p class=MsoNormal>alone<o:p></o:p></p><p class=MsoNormal>takes about a minute!).<o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'><br>Can you work out which queries take particularly long (I added some<br>progress<br>messages recently)?<o:p></o:p></p><p class=MsoNormal>Does QGIS need to do all of the checks it does when actually listing<o:p></o:p></p><p class=MsoNormal>the<o:p></o:p></p><p class=MsoNormal>tables?<o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'><br>Well, QGIS needs to know which geometry types are present. And that<br>might take<br>long to determine. It might be possible to do that lazy - ie. on<br>demand<br>(introduce another level to the tree where the types in the geometry<br>column<br>are.<o:p></o:p></p><p class=MsoNormal>Its also impossible to "add" a table while the list is being<o:p></o:p></p><p class=MsoNormal>generated so<o:p></o:p></p><p class=MsoNormal>the user has to wait until its finished before being able to<o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'>continue.<br><br>You can "stop" the detection and then pick what's already there.<o:p></o:p></p><p class=MsoNormal>Panning. Again, fine with smaller datasets, but the larger ones<o:p></o:p></p><p class=MsoNormal>cause<o:p></o:p></p><p class=MsoNormal>issues.<o:p></o:p></p><p class=MsoNormal><br>Do you have numeric primary keys? Otherwise QGIS must build a map that<br>assigns<br>numeric keys to the primary keys (or ROWID if there isn't any primary<br>key) on<br>the client side.<br><br>Jürgen<br><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<o:p></o:p></p></div></div><p class=MsoNormal>Software Engineer D-26506 Norden <a href="http://www.norbit.de" target="_blank">http://www.norbit.de</a> [5]<o:p></o:p></p><div><p class=MsoNormal><br>committ(ed|ing) to Quantum GIS IRC: jef on FreeNode<br><br>--<br>norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme<br>mbH<br>Rheinstrasse 13, 26506 Norden<br>GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502<br><br>_______________________________________________<br>Qgis-user mailing list<o:p></o:p></p></div><p class=MsoNormal><a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a> [6]<br><a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a> [7]<o:p></o:p></p><div><p class=MsoNormal style='margin-bottom:12.0pt'><br><br>This transmission is intended for the named addressee(s) only and may<br>contain sensitive or protectively marked material up to RESTRICTED and<br>should be handled accordingly. Unless you are the named addressee (or<br>authorised to receive it for the addressee) you may not copy or use<br>it, or disclose it to anyone else. If you have received this<br>transmission in error please notify the sender immediately. All email<br>traffic sent to or from us, including without limitation all GCSX<br>traffic, may be subject to recording and/or monitoring in accordance<br>with relevant legislation.<o:p></o:p></p></div><p class=MsoNormal>Links:<br>------<br>[1] <a href="http://www.bas-rhin.fr/" target="_blank">http://www.bas-rhin.fr/</a><br>[2] mailto:<a href="mailto:sylvain.pierre@cg67.fr" target="_blank">sylvain.pierre@cg67.fr</a><br>[3]<br><br><a href="http://testdrive.mapinfo.com/TECHSUPP/MIPROD.NSF/5c41496d5951a49c852562b5004f3a44/fcb3edc86ce9460b80256ae7004ee597" target="_blank">http://testdrive.mapinfo.com/TECHSUPP/MIPROD.NSF/5c41496d5951a49c852562b5004f3a44/fcb3edc86ce9460b80256ae7004ee597</a><br>[4] mailto:<a href="mailto:jef@norbit.de" target="_blank">jef@norbit.de</a><br>[5] <a href="http://www.norbit.de" target="_blank">http://www.norbit.de</a><br>[6] mailto:<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>[7] <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></p></blockquote><p class=MsoNormal><span style='color:#888888'><br><span class=hoenzb>-- </span><br><span class=hoenzb>--</span><br><span class=hoenzb>Andreas Neumann</span><br><span class=hoenzb>Böschacherstrasse 10A</span><br><span class=hoenzb>8624 Grüt (Gossau ZH)</span><br><span class=hoenzb>Switzerland</span></span><o:p></o:p></p><div><div><p class=MsoNormal><br>_______________________________________________<br>Qgis-user mailing list<br><a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">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><o:p></o:p></p></div></div></div><p class=MsoNormal><o:p> </o:p></p></div></div></body></html>