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

[Brendan Walashek]

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?

-- 
Thanks,
Brendan Walashek
www.golfingvancouver.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/cartoweb-users/attachments/20070502/3c4f53ed/attachment.html