[mapserver-users] drawQuery() takes forever...

[Pena Kupen]

Hi,

I have sent this to postgis-group, but forum is not maybe corrent one.
Sorry for crossposting...

--
Pena

Aihe: [postgis-users] drawQuery() takes forever...
Lähetetty: 24.7.2012 17:36
Lähettäjä: Pena Kupen [kupen at wippies.fi]
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 like following:

 select encode(AsBinary(force_collection(force_2d("koord")),'NDR'),'hex') as geom,"oid" from 
(
   select  ... [subpressed query]
) as foobar 
where koord && GeomFromText('POLYGON((3517739 7581169,3517739 7587169,3523739 7587169,3523739 7581169,3517739 7581169))',find_srid('','location','koord'))

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') as geom,"oid" from 
(
   select  ... [subpressed query]
) as foobar 
where koord && GeomFromText('POLYGON((3517739 7581169,3517739 7587169,3523739 7587169,3523739 7581169,3517739 7581169))',find_srid('','location','koord'))
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äällä! Varmista paikkasi vallankumouksen eturintamassa ja liity Wippiesiin heti!
http://www.wippies.com/