[mapguide-users] RE: ODBC performance

[Jon Rizzo]

Thanks for the information.  Not ideal, but perhaps I can cobble something
together to get me by until performance is improved.  I wonder if it would
be any better to use Access as a pass-through, linking to the tables from
SQL Server.  

 


Dave Wilson-3 wrote:
> 
> 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
> 
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

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