[postgis] Itemquery in postgis

[Ross.Searle]

Paul,

I have not let the query run to completion as the browser keeps timing out
so there is no way to seee if anything is going to be returned. I have both
a spatial index which works sensationally and an index on the item value
which appears not to be working.

Regards
Ross

-----Original Message-----
From: Paul Ramsey [mailto:pramsey at refractions.net]
Sent: Tuesday, 4 September 2001 4:13 AM
To: postgis at yahoogroups.com
Subject: Re: [postgis] Itemquery in postgis


Hm, does it take literally "forever" or does it just take a very very
long time? An index on the attribute value you are searching is a good
idea too... itemquery is something we haven't tested, so I bet there is
something amiss in the code.

Ross.Searle at dnr.qld.gov.au wrote:
> 
> Hi,
> 
> I'm trying to retrieve records from a large table in postgres through an
> itemquery in mapserver. It appears as if mapserver doesn't utilise the
index
> for the table as the same query run directly in postgres takes
approximately
> 1 sec whereas the same query through mapserver takes forever. Has anyone
got
> any clues as to what might be going on
> 
> Thanks
> Ross
> 
> ************************************************************************
> The information in this e-mail together with any attachments is
> intended only for the person or entity to which it is addressed
> and may contain confidential and/or privileged material.
> 
> Any form of review, disclosure, modification, distribution
> and/or publication of this e-mail message is prohibited.
> 
> If you have received this message in error, you are asked to
> inform the sender as quickly as possible and delete this message
> and any copies of this message from your computer and/or your
> computer system network.
> ************************************************************************
> 
> 
> To unsubscribe from this group, send an email to:
> postgis-unsubscribe at yahoogroups.com
> 
> 
> 
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 



************************************************************************
The information in this e-mail together with any attachments is
intended only for the person or entity to which it is addressed
and may contain confidential and/or privileged material.

Any form of review, disclosure, modification, distribution
and/or publication of this e-mail message is prohibited.  

If you have received this message in error, you are asked to
inform the sender as quickly as possible and delete this message
and any copies of this message from your computer and/or your
computer system network.  
************************************************************************

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Secure your servers with 128-bit SSL encryption! Grab your copy of VeriSign's FREE Guide: "Securing Your Web Site for Business." Get it Now!
http://us.click.yahoo.com/n7RbFC/zhwCAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/