[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] drawQuery() takes forever...
From:       Pena Kupen <kupen () wippies ! fi>
Date:       2012-07-24 14:36:47
Message-ID: 1371603170.1751343140608116.JavaMail.kupen () wippies ! fi
[Download RAW message or body]

Hello,

I have a postgres query, which takes about 0,1sek and resultset is one line=
 On my page, there is a link, which uses same sql tuo print koordinates to =
map.
When plotting to the maps, it's never ends.

I killed query from active task and pick sql from postgres log. It seems li=
ke following:

 select encode(AsBinary(force_collection(force_2d("koord")),'NDR'),'hex') a=
s geom,"oid" from =

(
   select  ... [subpressed query]
) as foobar =

where koord && GeomFromText('POLYGON((3517739 7581169,3517739 7587169,35237=
39 7587169,3523739 7581169,3517739 7581169))',find_srid('','location','koor=
d'))

When trying same with phpPgAdmin, first just my sql from same sql-sentence.
select  ... [subpressed query]
It takes same 0,1sek and one line as result.

When trying same query as whole
 select encode(AsBinary(force_collection(force_2d("koord")),'NDR'),'hex') a=
s geom,"oid" from =

(
   select  ... [subpressed query]
) as foobar =

where koord && GeomFromText('POLYGON((3517739 7581169,3517739 7587169,35237=
39 7587169,3523739 7581169,3517739 7581169))',find_srid('','location','koor=
d'))
It takes long time. After 15minutes, I killed query again.

Any idea, why this hungs? =

Am I doing something wrongly?
How to trace this?

--
Pena

-- =

Wippies-vallankumous on t=E4=E4ll=E4! Varmista paikkasi vallankumouksen etu=
rintamassa ja liity Wippiesiin heti!
http://www.wippies.com/


_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]