[Qgis-developer] Reverse Changeset 13499

[Chris Crook]

Hi

Yes .. It is wrong!  But the point of the estimated metadata isn't to get it right.  The point is that with very large tables, getting it right takes much too long - taking minutes to open layers (even if its only the first time with a lazy implementation) is very painful!

If the user wants it to be right (or at least, more nearly right), they don't have to use this option.  Even then it can still be wrong if another user is accessing and modifying the database.

Keeping the original implementation of the estimated metadata option gives the user the choice.

Cheers
Chris

-----Original Message-----
From: qgis-developer-bounces at lists.osgeo.org [mailto:qgis-developer-bounces at lists.osgeo.org] On Behalf Of Jürgen E. Fischer
Sent: Tuesday, 18 May 2010 4:51 p.m.
To: qgis-developer at lists.osgeo.org
Subject: Re: [Qgis-developer] Reverse Changeset 13499

Hi Jeremy,

On Tue, 18. May 2010 at 15:53:04 +1200, Jeremy Palmer wrote:
> I was wondering if it is possible to reverse
> https://trac.osgeo.org/qgis/changeset/13499 ?
 
> The reasoning behind the estimated metadata option is it only gets the 
> table row count from the table statistics, regardless of any filters.

But that's wrong, when there is a where clause.


Jürgen

-- 
Jürgen E. Fischer         norBIT GmbH               Tel. +49-4931-918175-20
Dipl.-Inf. (FH)           Rheinstraße 13            Fax. +49-4931-918175-50
Software Engineer         D-26506 Norden               http://www.norbit.de

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

_______________________________________________
Qgis-developer mailing list
Qgis-developer at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer
______________________________________________________________________________________________________

This message contains information, which is confidential and may be subject to legal privilege. 
If you are not the intended recipient, you must not peruse, use, disseminate, distribute or copy this message.
If you have received this message in error, please notify us immediately (Phone 0800 665 463 or info at linz.govt.nz) and destroy the original message.
LINZ accepts no responsibility for changes to this email, or for any attachments, after its transmission from LINZ.

Thank you.
______________________________________________________________________________________________________