Re: [Gnumed-bugs] GNUmed > Master_data_=3E_Manage_lists_=3E_Codes_and=85=A0hangs

[Karsten Hilbert]

On Thu, Jul 21, 2011 at 09:51:31AM +0200, Karsten Hilbert wrote:

> > Can I suggest that before opening the window, a query quickly determine
> > the total number of records in the table
> 
> That is not really possible unless "total number of records"
> gets defined much better.

Here is why:

        http://wiki.postgresql.org/wiki/Slow_Counting

The pg_class estimate is fairly fragile here because:

        - we would need to look up each child table of ref.coding_system_root
        - the children can change between releases, breaking the query

> (But we can add the "(this may take a while)" part which should
>  capture the gist of the problem.)

Done.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346