[web2py] Help Query speed

2013-01-22 Thread FERNANDO VILLARROEL
Dear. I have the follow problem. If i run the follows query in PgAdminIII is very fast: select rutas.id,rutas.nombre,ratecltes.rate from ratecltes joinrutas on rutas.id = ratecltes.id_rutas where ratecltes.id_clte=26 order by rutas.nombre But when i run the query on Web2py is very slow

Re: [web2py] Help Query speed

2013-01-22 Thread FERNANDO VILLARROEL
, FERNANDO VILLARROEL fvillarr...@yahoo.com wrote: From: FERNANDO VILLARROEL fvillarr...@yahoo.com Subject: [web2py] Help Query speed To: web2py@googlegroups.com Date: Tuesday, January 22, 2013, 6:54 PM Dear. I have the follow problem. If i run the follows query in PgAdminIII is very

Re: [web2py] Help Query speed

2013-01-22 Thread Bruno Rocha
maybe the virtual fields? --

Re: [web2py] Help Query speed

2013-01-22 Thread FERNANDO VILLARROEL
Ok but how i can solve? --- On Tue, 1/22/13, Bruno Rocha rochacbr...@gmail.com wrote: From: Bruno Rocha rochacbr...@gmail.com Subject: Re: [web2py] Help Query speed To: web2py@googlegroups.com Date: Tuesday, January 22, 2013, 10:10 PM maybe the virtual fields? --       --