<div dir="ltr">Hey,<div><br></div><div>Yeah I'm thinking it might just be slow for something like shapefile where is there no index on that column and it has to get each value to find the <span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13px">unique ones. I'm not looking at the code, just guessing.</span></div>
<div><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13px"><br></span></div><div><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13px">- Nathan</span></div></div><div class="gmail_extra">
<br><br><div class="gmail_quote">On Tue, Jul 15, 2014 at 4:09 PM, 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 Nathan,<br>
<div class=""><br>
On Tue, 15. Jul 2014 at 15:59:27 +1000, Nathan Woodrow wrote:<br>
> On Tue, Jul 15, 2014 at 3:57 PM, Jürgen E. <<a href="mailto:jef@norbit.de">jef@norbit.de</a>> wrote:<br>
</div><div class="">> > On Tue, 15. Jul 2014 at 07:12:22 +0200, Paolo Cavallini wrote:<br>
</div><div class="">> > > IMHO it should perform a quick LIMIT 10 query.<br>
<br>
</div><div class="">> > Have you verified that is doesn't? Because that's what it used to do.<br>
<br>
</div><div class="">> Seems it calls uniqueValues so if that takes a long time it will block.<br>
> Depends on the provider I guess.<br>
<br>
</div>Of course. LIMIT 10 probably is meant for the postgres provider - and that's<br>
what it does already. The spatialite provider does too. The oracle provider<br>
limits with "rownum" and mssql uses "top". So unless there's something<br>
preventing the provider's uniqueValues to kick in, it's already there.<br>
<div class="HOEnZb"><div class="h5"><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<br>
Software Engineer D-26506 Norden <a href="http://www.norbit.de" target="_blank">http://www.norbit.de</a><br>
QGIS release manager (PSC) Germany 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-developer mailing list<br>
<a href="mailto:Qgis-developer@lists.osgeo.org">Qgis-developer@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
</div></div></blockquote></div><br></div>