[mapguide-users] ODBC performance

[Dave Wilson]

Based on some testing it appears that the ODBC provider for SQL Server
is probably the slowest of the ODBC providers. Oracle, MySQL or Access
generally perform better. Given the new support of views it appears that
queries in Access can be used.

Regards,
Dave
-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Ivan
Milicevic
Sent: Wednesday, June 13, 2007 8:49 AM
To: MapGuide Users Mail List
Subject: RE: [mapguide-users] ODBC performance

I'm trying to keep my data in SDF file. The fastest one.

Have you tried with mySQL server? Postgre?

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Jon Rizzo
Sent: Wednesday, June 13, 2007 4:48 PM
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] ODBC performance



I just upgraded to 1.2 RC1 today and I loaded my site.  It looks like
there
are a lot of great new features - the new symbolization will be
particularly
helpful to us.  

I have been having performance issues on my site, which seem to be
related
to an ODBC feature source which I have joined to an SDF feature source.
The
ODBC database is running on the same server as MapGuide.  It takes
several
seconds (between 5 and 10) for the viewer to display the user's
selection,
and about the same amount of time for my page to load initially.
Depending
on who you ask, opinions of my site vary from 'annoying' to 'useless'.
The
poor performance is particularly surprising because the layer only has
about
100 polygons on it, and the other layers are not particularly complex
either.  I have posted about this issue previously & was advised that
there
would be improvements in the new version which might help.  I tested my
application in 1.2 RC1 and I was disappointed to find that the upgrade
did
not have an effect on the performance of my application.   Is there
anything
that can I can do to improve performance here (and not lose the ability
to
theme or label extended properties)?  Is there still work being done to
address ODBC performance issues, or is my situation unique?  Thanks for
any
information you can provide.

Jon


-- 
View this message in context:
http://www.nabble.com/ODBC-performance-tf3915161s16610.html#a11101110
Sent from the MapGuide Users mailing list archive at Nabble.com.

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users