Interesting : http://stackoverflow.com/questions/13855304/slow-count-on-postgresql-9-2
Richard On Mon, May 6, 2013 at 9:35 AM, Richard Vézina <ml.richard.vez...@gmail.com>wrote: > Read the link of Niphold that were broken and it seems that the slow > counting is gone in Postgres 9.2 > > Richard > > > On Mon, May 6, 2013 at 9:34 AM, Richard Vézina < > ml.richard.vez...@gmail.com> wrote: > >> http://wiki.postgresql.org/wiki/Slow_Counting >> >> >> On Mon, Apr 23, 2012 at 6:53 AM, Niphlod <niph...@gmail.com> wrote: >> >>> unfortunately counting on postgres is a heavy operation, and it's pretty >>> "famous" for this http://wiki.postgresql.org/wiki/Slow_Counting......... >>> maybe you can try limiting the amount to, let's say, 20000 (if it's >>> possible as per requirements of your app) and see if there are differences. >>> >>> In theory >>> >>> SELECT COUNT(*) from mytable >>> >>> and >>> >>> SELECT COUNT(*) from mytable LIMIT 20000 >>> >>> for a 500000 records table is faster. >>> >>> You could have a "default" grid of the 20000 records and then an >>> "advanced" if users are willing to scroll over the n-thousand-x page. >>> >> >> > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
