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-boun...@lists.osgeo.org
[mailto:geos-devel-boun...@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.sew...@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
