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

List:       geos-devel
Subject:    RE: [geos-devel] Nightly build performance
From:       "James.Sewell () lisasoft ! com" <James ! Sewell () lisasoft ! com>
Date:       2011-02-21 1:14:31
Message-ID: CB506E813C77E9498F043F1F951BB2768E3B982981 () optimus ! ms ! a2end ! com
[Download RAW message or body]

Hey,

6774 was the 2.0 SVN id.

I will test again with no indexes later when my machine is idle.

Cheers,
James Sewell 
Developer 
LISAsoft 

Ph: +61 3 8680 3250 Fax: +61 3 8680 3299 
Level 9, 601 Bourke St, Melbourne Vic 3000


LISAsoft is part of the A2end Group of Companies
http://www.ardec.com.au
http://www.lisasoft.com
http://www.terrapages.com


-----Original Message-----
From: geos-devel-bounces@lists.osgeo.org [mailto:geos-devel-bounces@lists.osgeo.org] \
                On Behalf Of Sandro Santilli
Sent: Friday, 18 February 2011 6:23 PM
To: GEOS Development List
Subject: Re: [geos-devel] Nightly build performance

On Fri, Feb 18, 2011 at 01:52:47PM +1030, James.Sewell@lisasoft.com wrote:

> The issue I have noticed is that the newer version is noticeably (more than 5x) \
> slower on some large queries of the form: 
> 	SELECT a.geom FROM left AS a, right AS b    
> 		WHERE st_intersects(a.the_geom, b.the_geom);
> 
> 
> Have there been changes in this area of the code? Is this expected for nightly \
> builds? Is there anything I can do to help troubleshooting of the issue? All my \
> tables are imported and indexed by the same tool in both instances.

If you can, compare again, using _st_intersects (skips the index).
And keep track of GEOS svn id of the source if they are different.

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html
_______________________________________________
geos-devel mailing list
geos-devel@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/geos-devel
_______________________________________________
geos-devel mailing list
geos-devel@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/geos-devel


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