[Qgis-user] Database design/performance question

[Bernhard Ströbl]

Hi Koos,

I do not know about Spatialite. In PostGIS if your data is on the _same_ 
server it should not matter if it is organized in one or several 
databases. You can, however, increase performance
a) hardwearwise: use a Raid-System, increase RAM (and tell PostgreSQL to 
use it -> postgresql.conf)
b) datawise: create a spatial index, use VACUUM, probably CLUSTER the 
data by this index as I understand you only read the data.

as for schemas: compare with your file system: You could put all your 
shape files in the same directory or create subdirectories

Bernhard


Am 09.05.2012 08:48, schrieb 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
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
> ________ Information from NOD32 ________
> This message was checked by NOD32 Antivirus System for Linux Mail Server.
> http://www.nod32.com



________ Information from NOD32 ________
This message was checked by NOD32 Antivirus System for Linux Mail Server.
http://www.nod32.com