[postgis-devel] Prepared Geometry API

[Obe, Regina]

Paul,
> Remember, it's not differences we're going to be finding, it's
> similarities. My main test case was 8000 small geometries in 80 large
> ones. That means a given spatial join did (at least) 8000 tests, and
> for 7920 of them, the answer was "yep, the cached geometry is still
> the same as the incoming geometry". Only in 80 of the tests was the
> answer "geometries differ, recache!"

I'm sorry I still don't get it.  I'm hoping a duh moment will hit me soon and I can be more sympathetic here.  I hate not being sympathetic to things I don't understand.


1) So you have a cache already or is that if you were to go with this ID thing? I thought you already have prepared working so we have caching happing already no?
2) If you have a cache already, are we caching both the left argument and the right argument now or just one? 
3) You pass the id in the first time it sees the id, you cache the geometry using the id as a key to pull it out later.
4) Second time you see the id, you just pull it from the cache? (I still think you need an index by the way Mark to make this efficient for large numbers of large geoms to efficiently pull out of the cache, but that's besides the point I guess)
5) You are making Intersects and contains and all that other stuff order dependent (e.g. now I have to pass in the big geometry first or second and the id of the big geometry)?


Thanks,
Regina





-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20081006/6431a8f6/attachment.html>