[Cartoweb-users] Shapefile size and speed DB or native?

Nicolas Ribot nicolas.ribot at camptocamp.com
Thu May 3 04:57:10 EDT 2007

> I have a 1 GB shapefile (yes, 1 GB!), as it is the footprints for  
> ALL the IKONOS satellite imagery for the entire world.  Other than  
> breaking up the file, using the native shapefile in Cartoweb and  
> querying it would probably take a LONG time.  Is storing this file  
> in a PostgreSQL/PostGIS Spatial database any faster?  I understand  
> you can index the file in the database version to speed up searches  
> etc., but is this file just way too big to begin with no matter  
> which method I use?
> Anyone have experience with working with a shapefile this big and  
> trying to access it over Cartoweb?  Or the speed difference using a  
> spatial DB?

I think it is worth reading this postgis post regarding this issue:


Personnally, I think using postgis as repository is a good choice.
Well crafted index will help querying the data


More information about the Cartoweb-users mailing list