[postgis-users] Performance question (how many years will this take?)

[Wood Brent]

> Iterating outside the database seems to be incredibly efficient. I did 3 
> million fairly complex iteractions (pulling 10-200 records each and 
> analyzing them for time series properties) against a 50 million record 
> table, with run times of under an hour for the whole analysis. And the 
> program was in perl (like all great programs).


I didn't realise PostGIS/GEOS/GDAL were written in Perl :-)

Thanks,
  
   Brent