[Qgis-user] Database design/performance question

[Koos Hagg]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20120509/bb5f91ac/attachment.html>