[Geomoose-users] [mapserver-users] PostGIS or Mysql and GeoMoose.

[Jim Klassen]

I'll try to answer question 1 as the others have been answered already.
 
GeoMOOSE mostly is using mapserver in CGI mode so any data source supported by Mapserver should work fine. I've used SHP, WFS, OracleSpatial, PostGIS and Various OGR data sources successfully.
 
There are also some PHP/Mapscript services that ship with GeoMOOSE which also should work fine with any Mapserver supported data source, but I haven't personally tested them.
 
In my experience tileindexed shapes with all associated .qix files is faster than using a spatial database on the same hardware. (Although PostGIS comes very close in speed and adds a lot of flexibility in terms of types of queries that can be executed and how easy it is to update the data.)

Jim

>>> On 5/13/2008 at 8:55 AM, "Fawcett, David" <David.Fawcett at state.mn.us> wrote:
I would be surprised if you actually get a performance gain from using a
spatial db over a well optimized (tiled, indexed, overviews) set of
shape files.  Using the spatial db definitely gives you some more
flexibility, but I would doubt that it would out perform the shapefiles.


I am not completely sure what you are asking in question #1, but a
MapServer WMS service based on a PostGIS layer shouldn't look any
different to GeoMoose than one based on shapefiles.

-----Original Message-----
From: mapserver-users-bounces at lists.osgeo.org 
[mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Nelson
Soto
Sent: Tuesday, May 13, 2008 7:56 AM
To: mapserver-users at lists.osgeo.org 
Subject: [mapserver-users] PostGIS or Mysql and GeoMoose.


For performance reasons, I may need to convert SHP's into a spatial
database. I loosely understand the concept of how this work but my
questions to anyone reading are:

1. Has anyone looked into specifically doing the above with their
working demo of GeoMoose using SHP files previously? I would hate to
scrap the work I've done utilizing the excellent usability of GeoMoose
in favor of utilizing a spatial database.

2. If users are typically accessing data but not writing it, will I
realize a performance upgrade *typically*.

3. Is there any functionality I can expect to break and essentially head
into an 'uncharted territory' if I did indeed attempt this. Can I
basically expect to find in my way a high level of techincal issues (I'm
very technical, but I am trying to find an efficient approach)

Also, here is a description of what I had attempted to do...

We have an OS X server which contains 2 dual core Xeons processors and
4GB of ram. We are mainly a Windows house and had aquired the hardware
in an anquisition and would like to utilize this hardware as best as
possible. This is one of our more ambitious products we one day would
like to offer our clients (we currently offer an Access product that is
quite dated.).

Originally, I had suggested perhaps getting Parellels VM software and
just bringing a copy of Windows Server 2003 to the table, but my
performance almost seems better on my test machine... I'm not sure if
that will apply to concurrent users which is certainly an aspect of the
issue at hand, but the VM software only detects 1 core... not good. We
are not looking at VMWare or anything where the license will exceed or
approach the cost of a new server otherwise we will do so.

If I host PostgreSQL or MySQL on the server and away from the server
that would host GeoMoose (a new server) I would hopefully like to
utilize the Mac in this way seeing as how I can not get the performance
I would like out of virtualized hosting.

Yes, I realize I can just set up Mapserver for OS X but, in my oppinion,
it is a very laborious task and I am foreseeing I will be the one having
to maintain this server and while I myself and relatively comfortable
maintaining OS X and its Unix skeleton, I want to minimize the work I
need to do to this server...

I will post this on GeoMoose mailing list as well as Mapserver as I
realize there is some overlap in exactly what area's this does cover.
While the context of this topic does cover my use of GeoMoose with
Mapserver, I'm thinking there are users on both of these lists that have
experience with the advantages vs disadvantages of Spatial DB Data vs
SHP on disk.

At any rate, any input is appreciated.

Thanks,
Nelson
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org 
http://lists.osgeo.org/mailman/listinfo/mapserver-users 
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org 
http://lists.osgeo.org/mailman/listinfo/mapserver-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/geomoose-users/attachments/20080513/1f636608/attachment.html