From: Andrea A. <and...@al...> - 2004-05-08 08:16:43
|
Alle 02:28, sabato 8 maggio 2004, Jody Garnett ha scritto: > Brent and I have been having fun today with Postgis & Geotool2 (by way > of the validation module). > > We have been playing with a large data set (260K Features, 88 megs) and > have been checking for overlaps (well actually not disjoint): > > What we have learned: > - Use a Transaction with your FeatureSource (or the DataStore will leak > connections) > - Use of not(disjoint) is really encoded as not(not(intersects)) by the > DataStore > - Not calling FeatureReader close (and thus leaving your statement, or > result set open) will cause the database Postgis to leak memory - used > up 2.8 gigs in 1/4 the data > > It would be interesting to perform this same test with Andrea's > datastore branch. Please do, but remember to download the latest postgres driver from the postgres web site, the one in the maven repository has a few bugs that won't let the test suit succeed. Anyway, performance and filter econding wise it should be the same. Best regards Andrea Aime |