Steve;
Do you have the concept of a "master" SRID? In other words, is there a
projection in which you do all of your maintenance / updates?
If so, you could consider keeping that as your "main" / "master" table,
and either creating your other "tables" as views with on-the-fly
projections from that table, or create the entries automatically in
other tables using insert / update / delete triggers.
A problem to consider with keeping everything in one table is that the
wider your rows, the more I/O you have to do to read and write rows. So
if you have application A reading SRID 1 and application B reading SRID
2 you will probably find better throughput by physically separating the
table. Worth testing, anyway.
Also, with separate tables, especially tables that are not heavily
maintained, you can try clustering your indexes to improve your performance.
[email protected] wrote:
Hello,
We need to use a table for several purposes with different SRID.
Is it a good practice to have several geometry columns on one table or
should we create one table per SRID?
What are the pros and cons of using several geometry columns on one
table?
thanks
Steve
/Steve Toutant, M. Sc./
Analyste en géomatique
Secteur environnement
Direction des risques biologiques, environnementaux et occupationnels
Institut national de santé publique du Québec
945, avenue Wolfe
Québec, Qc G1V 5B3
Tél.: (418) 650-5115 #5281
Fax.: (418) 654-3144_
[email protected]_ <mailto:[email protected]>_
__http://www.inspq.qc.ca_ <http://www.inspq.qc.ca/>
------------------------------------------------------------------------
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Regards, (please note new mobile number below)
Chris Hermansen mailto:[email protected]
tel+1.604.714.2878 · fax+1.604.733.0631 · mob+1.778.840.4625
Timberline Natural Resource Group · http://www.timberline.ca
401 · 958 West 8th Avenue · Vancouver BC · Canada · V5Z 1E5
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
