[Qgis-developer] Sample

[Jürgen E. Fischer]

Hi Paolo,

On Tue, 15. Jul 2014 at 08:50:10 +0200, Paolo Cavallini wrote:
> > 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 unique ones.  I'm
> > not looking at the code, just guessing.
> 
> Thanks for your comments.
> I found it rather slow for large PostGIS tables.

As slow as

SELECT DISTINCT attribute FROM table ORDER BY attribute LIMIT 10

?


Jürgen 

-- 
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