[Qgis-developer] Sample

Jürgen E. Fischer jef at norbit.de
Mon Jul 14 23:09:03 PDT 2014

Hi Nathan,

On Tue, 15. Jul 2014 at 15:59:27 +1000, Nathan Woodrow wrote:
> On Tue, Jul 15, 2014 at 3:57 PM, Jürgen E. <jef at norbit.de> wrote:
> > On Tue, 15. Jul 2014 at 07:12:22 +0200, Paolo Cavallini wrote:
> > > IMHO it should perform a quick LIMIT 10 query.

> > Have you verified that is doesn't?  Because that's what it used to do.

> Seems it calls uniqueValues so if that takes a long time it will block.
> Depends on the provider I guess.

Of course.  LIMIT 10 probably is meant for the postgres provider - and that's
what it does already.  The spatialite provider does too.   The oracle provider
limits with "rownum" and mssql uses "top".  So unless there's something
preventing the provider's uniqueValues to kick in, it's already there.


Jürgen E. Fischer           norBIT GmbH             Tel. +49-4931-918175-31
Dipl.-Inf. (FH)             Rheinstraße 13          Fax. +49-4931-918175-50
Software Engineer           D-26506 Norden             http://www.norbit.de
QGIS release manager (PSC)  Germany                    IRC: jef on FreeNode                         

norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
Rheinstrasse 13, 26506 Norden
GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502

More information about the Qgis-developer mailing list