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
[email protected]
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
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
