David, I honestly can't answer this yet but will when I can. Right now it's an
apples to oranges comparison. The sql server is a big beefy dedicated server
and postgres is just running on a VM. Also one is using a geoserver sql view
and the other a sql server native view.
But I am lobbying to take a spare server and put xen on it, and a nice beefy VM
for postgres/postgis and also run geoserver on a linux VM and then I think it
would be a more fair comparison, and will report back.
charles
On Mar 4, 2011, at 2:48 PM, David Collins wrote:
> Charles,
>
> Since you have used both PostGIS and SQL Server with the same data, I am
> interested in any performance comparison. How do they compare to each other,
> when used with Geoserver ?
>
> Regards,
> David
>
> On Sat, Mar 5, 2011 at 12:13 AM, Charles Galpin <[email protected]> wrote:
> Thanks David
>
> Yes geometry seems to work and that's fine for me too afaikt.
>
> I was trying to use the sql view feature (2.1) which was giving me the
> byte[], but I switched to actual views in the database and could use geometry
> columns. I also have to avoid the nvarchar type or geoserver skips these
> columns, but otherwise it seems to be working ok.
>
> charles
>
>
>
------------------------------------------------------------------------------
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
