How about spatialite? Does it suffer from performance issues when a file gets large (say ~1GB)?
Etienne On Wed, May 9, 2012 at 9:36 AM, Andreas Neumann <[email protected]> wrote: > Hi, > > Performance wise it does not matter whether you have one or multiple > databases. You can also split a single database into multiple tablespaces on > multiple disks. > > I would opt for one big database for everything. Table joins across multiple > databases is complicated and does not work out of the box in PostgreSQL. The > only drawback with one big database is that the dump files (backup or > migration) get fairly large. > > Andreas > > > On Wed, 9 May 2012 13:48:38 +0700, Koos Hagg wrote: >> >> Hi all, >> >> Only recently have I started using databases more often. I like >> Spatialite for its single file solution, I can easily share data with >> others... PostGIS is great too, happy that they have 64 Windows now. >> >> Performance wise- in QGIS: >> Is it better to have one big Database (PostGIS or Spatialite or >> whatever) with all of your layers/tables in there, or to have several >> smaller databases, each containing their own family of data >> >> For example, >> I could have one database for OSM data from Geofabrik, one database >> with Natural Earth data, and one database with my own data., etc >> >> -or- >> >> I could stuff all of those into one big database. >> >> Which approach is the better practice? Will accessing several >> databases in QGIS at the same time vs one big db be any different in >> performance? >> >> If I'm working with PostGIS, would it make sense to separate the >> different data groups (OSM, Natural Earth, etc) into different >> schemas? Would there be any benefit to that? >> >> Thanks! >> >> Koos > > > -- > -- > Andreas Neumann > Böschacherstrasse 10A > 8624 Grüt (Gossau ZH) > Switzerland > > _______________________________________________ > Qgis-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
