<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:10pt"><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">Actually, I've been using GeoMOOSE with PostGIS and the City of Saint Paul is using it with a few Oracle databases. GeoMOOSE doesn't really care about the data source, it's going to be more mapserver. So I'd suggest hitting put the mapserver website for tips, hints, and limitations for connecting to the various datasets.<br><br>If you are using the python based printing service there may be some "hiccups" but 1.4 (which I keep promising and keep over thinking and fixing things) should be coming by this weekend (G-d willing) with the new PHP-based print service which should be more widely compatible.<br><br>Now, the performance increase, will you see one? I doubt it, unless your dataset is very, very, very large, and even then
the benefit is arguable. Mapserver is very good about using shapefiles and can use them very well. There are options to improve the speed of shapefiles too. I believe the process for creating indexes and tiling is located some where on the mapserver website and/or I think others here (Bob?) can chime in on the exact process.<br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: Nelson Soto <nellyfromma@gmail.com><br>To: geomoose-developers@lists.sourceforge.net; geomoose-users@lists.sourceforge.net<br>Sent: Tuesday, May 13, 2008 7:53:28 AM<br>Subject: [Geomoose-users] SHP converted into PostGIS or MySQL<br><br>
For performance reasons, I may need to convert SHP's into a spatial<br>database. I loosely understand the concept of how this work but my<br>questions to anyone reading are:<br><br>1. Has anyone looked into specifically doing the above with their<br>working demo of GeoMoose using SHP files previously? I would hate to<br>scrap the work I've done utilizing the excellent usability of GeoMoose<br>in favor of utilizing a spatial database.<br><br>2. If users are typically accessing data but not writing it, will I<br>realize a performance upgrade *typically*.<br><br>3. Is there any functionality I can expect to break and essentially<br>head into an 'uncharted territory' if I did indeed attempt this. Can I<br>basically expect to find in my way a high level of techincal issues<br>(I'm very technical, but I am trying to find an efficient approach)<br><br>Also, here is a description of what I had attempted to do...<br><br>We have an OS X server which contains 2
dual core Xeons processors and<br>4GB of ram. We are mainly a Windows house and had aquired the hardware<br>in an anquisition and would like to utilize this hardware as best as<br>possible. This is one of our more ambitious products we one day would<br>like to offer our clients (we currently offer an Access product that<br>is quite dated.).<br><br>Originally, I had suggested perhaps getting Parellels VM software and<br>just bringing a copy of Windows Server 2003 to the table, but my<br>performance almost seems better on my test machine... I'm not sure if<br>that will apply to concurrent users which is certainly an aspect of<br>the issue at hand, but the VM software only detects 1 core... not<br>good. We are not looking at VMWare or anything where the license will<br>exceed or approach the cost of a new server otherwise we will do so.<br><br>If I host PostgreSQL or MySQL on the server and away from the server<br>that would host GeoMoose (a new server) I
would hopefully like to<br>utilize the Mac in this way seeing as how I can not get the<br>performance I would like out of virtualized hosting.<br><br>Yes, I realize I can just set up Mapserver for OS X but, in my<br>oppinion, it is a very laborious task and I am foreseeing I will be<br>the one having to maintain this server and while I myself and<br>relatively comfortable maintaining OS X and its Unix skeleton, I want<br>to minimize the work I need to do to this server...<br><br>I will post this on GeoMoose mailing list as well as Mapserver as I<br>realize there is some overlap in exactly what area's this does cover.<br><br>At any rate, any input is appreciated.<br><br>Thanks,<br>Nelson<br><br>-------------------------------------------------------------------------<br>This <a target="_blank" href="http://SF.net">SF.net</a> email is sponsored by: Microsoft <br>Defy all challenges. Microsoft(R) Visual Studio 2008. <br><a
href="http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/" target="_blank">http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/</a><br>_______________________________________________<br>Geomoose-users mailing list<br><a ymailto="mailto:Geomoose-users@lists.sourceforge.net" href="mailto:Geomoose-users@lists.sourceforge.net">Geomoose-users@lists.sourceforge.net</a><br><a href="https://lists.sourceforge.net/lists/listinfo/geomoose-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/geomoose-users</a><br></div></div></div><br>
</body></html>